I usually use 5 Workbooks (Week-1,Wee-2,Week-3,Week-4 and Master) but for this example lets use “Week-1” and “Master” workbooks.

I currently use the formula as shown below to reference the data from the Week-1 workbook into the a certain group of cells in the “Master” Workbook.

='[Week-1.xlsx]Sheet1‘!$D$5:$D$41    and then Cntr +Shft+Entr

Since there are 350 different sheets I was wondering if there is a faster way to increment the “sheet” reference when I copy/ paste this formula in say sheet2 or sheet3 without me having to manually change them for every corresponding sheet.


Thank you for your help.

By: Jeffery Thomas

Leave a Reply

Your email address will not be published. Required fields are marked *