Hi
I have a central spreadsheet that will be fed by around 20 identical reports (apart from the data).
I am using the simple formula below to pull it together (will be refreshed monthly and the file names will be the same)
='C:\File path\[Report 1.xlsx] Main Report Report '!$C$9
='C:\File...