Q:

How to get cell with row and column number by referencing to cell

I have this simple spreadsheet:

I need to get a number value from a different spreadsheet called WEEKS. Now I am using a function 
=WEEKS!J11

I have different numbers as well
=WEEKS!L11
=WEEKS!K11
...

Next week I have to update manually the end-number 11 to 12 and every week I have to do the same. I'd prefer to do it easier by referring to get the column number from another cell. For this, I created cell called Week with a current number / week and I want to update it every week and update automatically all the numbers. So now we have:
N8 = 11

=WEEKS!J11
=WEEKS!L11
=WEEKS!K11

If I change N8 to 12, then automatically:
=WEEKS!J12
=WEEKS!L12
=WEEKS!K12

How could I do it?

A:

Use INDIRECT like this:
=Indirect("Weeks!J"&N1)

