VBA double-loop search and copy

Hey ya'll,
Once again, I've searched the forum and Google for the answer and I cannot find it, so I'm hoping it's locked away in someone's wisdom on this forum.
I don't know how to begin with this one, but I've got an idea what I need.

What I'm looking for is, as the title suggests, Is a loop within a loop to search a specific cell on every worksheet, in every file in a specific list. I've tried searching for "search" VBA codes, for "loop" VBA codes and I don't know either good enough to bend them to my needs, nor to combine them (usually, I just end up messing the whole thing up so I can't even fix it).

In the posted example, I put the three pages for the example and manually entered the information I'm looking for.
The basics are:
1) Outer loop: search for a file, with an increment-able cell reference as part of the filename.
2) Inner loop: search each worksheet, with an increment-able cell reference as the whole worksheet name.
3) Copy the cell $D$1 (of the example) off each worksheet to the table on the MasterTrack file.
Each worksheet in the Searched-For file is a specific name represented by the cells of Column A on the YahBoh worksheet of the MasterTrack file.
Each Searched-For file begins with "Yadayada" and contains a specific name in the cells of Row1 on the YahBoh worksheet of the MasterTrack file.
The same cell ($D$1 of the example) will be copied from every worksheet, so there's no need for a 'search term' with that.

I hope I explained this clear enough. If you have a start, a website that'll show something relevant, anything will help.

Please, thank you.

Steve, technically your code did look in the directed folder, took the information I was looking for and copied it to the Master file. However: 1) the code itself was very confusing and I wasn't sure where to interject my example files' to get it to run on the example sheet and 2) when the data was copied to the Master file, it copied over the bottom row instead of in the table.

ggs22,
That works great! I don't know how you made it look so simple, but that's just what I was looking for! Thank you, so much.

Its a pleasure! (don't forget to mark it as solved)