Vlookup to change worksheet reference

[ChrisHowk]

I am trying to do a Vlookup across 17 different worksheets and it is getting old manually changing the worksheet reference so I was hoping there was a work around. This is the function that I currently have:

=VLOOKUP(A60,Week1!$A$1:$H$16,5)

I would for "week1" to change to "week2","week3" and so on as I copy the formula across. The table reference stays the same on the the sheets as well as the lookup value.

If it helps, the table I am trying to copy the formula across in has the same headings as the worksheets.

Any help would be appreciated.