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.


Here is the REF video https://www.youtube.com/watch?v=mvYYZNUe_9s
.



This is the video I'd like to copy https://www.youtube.com/watch?v=vliCSzCrrR4&t=17s
the guy says no need to buy expensive program when you can do it in excel yet doesnt provide an link to download the code or provide a tutorial

.

The video above uses buttons/vba in excel and I badly need it. This doesnt help either http://www.vbaexpress.com/kb/getarticle.php?kb_id=405 Nor this one https://www.youtube.com/watch?v=OSCPVBWOqwc




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.