I have 2 workbooks.

Each workbook contains 46 sheets and I call them week numbers 1 to 46 on both workbooks.

Each workbook is unique however the 46 sheets are identical in each of their respective workbooks.

So the first workbook I am trying to put a link formula into cell A3 say for week 1 .
The information I am putting into that cell would be the data from G3 in week 1 of the other workbook.

Once I put the formula into the first workbook in cell A3 I then will drag the formula from A3 to B17 which will then get the data from the 2nd workbook from cell G3 to H17.



I can do that part quite easy as I just link the two cells straight away no problem. I then want to do the same with all of the other sheets in the work books for week 2 to week 46. I can do that easy enough but it is very time consuming.

I then have an additional 25 workbooks in the same format as workbook 1 that I want to repeat the function as I have done with workbook 1. All the other workbooks would be linked to workbook 2.

As I say I can do it ok but it is very time consuming and was hopeful I could take the workbook1 and select all sheets so that then I only have to do the link and drag once with the other workbooks 2 to 46 all having their own week number on it

.E.G cell A3 ='[workbook1.xlsx]week 1'!G3 and then repeated for each sheet so the next sheet would say ='[workbook1.xlsx]week 2'!G3 and so on.

https://youtu.be/qeacYk8XF4w

Is there a quick workaround with this at all?