Hello, I'm trying to create a summary sheet. I have template documents that are identical accept for the values. I want to be able to create a formula that I can drag down a column that will adjust the file it is linked to by 1. ie in cell A1 links to 'File1!A1', B1 links to 'File2!A1', and so on I have played around but really cant figure it out??
Thank you in advance
Bookmarks