I have a spread sheet with many tabs - linked to project number. For example tab 9999 will contain data about project 9999.

I have a list of project numbers.

I want to know how to get excel to read the value in the cell, and go to that tab to retrieve the relevant information:

for example in the project number list cell A1 is the written project number: 9999

The data I want put in cell B1 would be data from tab 9999.eg ='9999'!$L$2

Instead of manually inputting 9999 I would hope that ='=A1'!$L$2 would work.

It doesn't, is there a way to do this? I have hundreds of projects and references related to the project number and project tab,

I need excel to just read what the text in the cell is, and go to that tab.

I'm getting confused just trying to explain what I need!

Any help would be great!