How to correct INDIRECT using VLOOKUP

I have several worksheets by week to week for bowling results.
Every week I would have to copy previous week worksheet to new worksheet and name it, eg. 1st worksheet called 'Week1', 2nd worksheet called 'Week2' and so on.

I have several VLOOKUP on each worksheet that each will look previous week worksheet using worksheet name. See Red Text below that I want to change....

FOR EG...
=VLOOKUP(A7,Week2!$A$286:$J$313,5)

See red text above (Week2) when I copied the previous week (Week2) to new worksheet (Week3) but the VLOOKUP still shows as Week2 I have to change every VLOOKUP to Week3 and so on for every week.
TOO MUCH WORK TO DO THIS SO...

I am trying to correct the VLOOKUP using INDIRECT see below (something like this), but I couldn't get the code right can you help.

=VLOOKUP(A7,INDIRECT("Week"&RIGHT($A$3,LEN($A$3)-5)-1&!$A$286:$J$313,5))
(Note: In cell A3 = Week 3 as current week for example)

Thank you for your help.

Try this

Please Login or Register  to view this content.

Does that work?

Try this?

=VLOOKUP(A7,INDIRECT("Week"&RIGHT($A$3,LEN($A$3)-5)-1&"!$A$286:$J$313"),5)