Catcy title? Got your attention didn't I!

I am new to the forum, and VBA as well. I am familiar with the record options, but going in and changing a little to a large document and changing each piece of information. Here is my goal

I have a workbook that contains a few work sheets.
Report Number 1 2 3 4
1 Linked to Report 1 Box C5 Linked to Report 1 Box D5 Linked to Report 1 Box E5 Linked to Report 1 Box F5
2 Linked to Report 2 Box C5 Linked to Report 2 Box D5 Linked to Report 2 Box E5 Linked to Report 2 Box F5

If this was only a couple of reports, wouldn't be bad, but it could consist of 200+ Reports, with many different boxes. Any help would be appreciated.