Hi,

I'm trying to call data from specific workbooks i.e:

I have 48 workbooks all labeled as follows: WK1, WK2, WK3 and so on up to WK48. All of these workbook are in the same layout only the data in the tables vary.

I have a table in a seperate wookbook that extracts the data from the relevant week. For example:

WK41 WK42 WK43 WK44
A 7 3 6 5
B 0 4 8 2
C 1 9 5 1


I would like the data to update manually if I alter the week number in the table header. e.g.

WK43 WK44 WK45 WK46
A 6 5 8 7
B 8 2 4 9
C 5 1 2 3

Is this possible?


Thanks in advance