Can someone tell me what are the functions I need so I can just figure out to put them together. Thanks.

or

make tutorial on How can I extract all the files from my folder and extract it into excel with filter using just a couple of buttons?
Like one button extracts all files from folders and subfolders that has pdf and png extensions. Other button updates the list if the files are moved or removed. Other button Prints the list correctly.




NOTE: Im aware that there is a software called Directory List but this is not what I want. I want knowledge and share it to others.