Copy/Paste from multiple wbks same folder

I am trying to create a document that will pull Rows 16 & 79 from ALL the other workbooks in the folder my Summary document is in - not looking to make it a specific folder because I have multiple folders with various files (i.e. Blue files, Red files, Yellow files, etc). I'll just drop my Summary file in the folder I need, run it and then grab the info before I drop it into another folder.

I found a few different solutions but they all seem to want to look in a specific folder. I also would like it to jump rows when it's pasting from each book. I created a template of the Summary file I'd ideally like to put together.

The books it will pull from will always have the same sheet name, although there won't always be 20 of them - I just picked the largest number would be in any one folder.

Any help would be appreciated.

jolivanes - I've modified your macro a bit but overall I really like it. It even labels Col A by using my file names - I only used Book 1-8 as default names. This is a step I would've done later, so time saved

I did notice something that I'm sure is an easy fix that is just going over my head at the moment.
1. Instead of taking the data from Jan 24-Dec 24 (in blue on Book1), it's taking Jan 23-Nov 23 (in yellow on Book1) + the Row heading from Col B (both happened to be "PSIH"). Ideally it would match the dates from Row 1 on Summary and Row 3 on the books in the folder and bring back the applicable data from Rows 16 and 79.

I've provided a stripped down version (taking out sensitive data) of one of the books I'll actually be using.

Thank you very much jolivanes! While I haven't implemented your solution to my date matching yet , your explanation of how to change the columns I'm looking at worked perfectly. And I thank you for explaining how that change works so I will learn in the future.