Populating a Summary Workbook

Hi all, very new excel user here

I'm currently working on a progress summary report that takes cell data from multiple workbooks.

For example, I have a cell in the summary called "ISOs" that adds up the number of ISOs on each individual report.

The way I was shown to do it, hitting "=" in the summary then clicking each ISO cell in the individual reports separated by "+" seems a tad cumbersome, especially since the formula is similar for each cell I'm populating. (ex. getting data from '[File1]File1'!$D$14, for the ISO cell and '[File1]File1'!$D$15 for the Checked cell)

I've got anywhere from 15-50 different reports I'm linking data from so I was wondering if there was a way to copy the formula and auto update the cell numbers or file numbers. I thought of doing a find and replace but I can't quite seem to figure it out (again pretty much first-timer here).

If anyone has experience with similar projects I'd love to hear any suggestions.

Also if I need to explain anything clearer just let me know.

Thanks!

Hi Pepe!

Thanks for your prompt reply.

Does the 3d reference mentioned in your link work for multiple excel files? We have the reports separated by area, so they aren't multiple sheets of one workbook, rather separate files.

Thanks again for any advice!