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