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.