Using data in a cell to look in a sheet of the same name

[nickels]

Wondering if anyone can help me out

I have a list of account codes in a "Summary" sheet. I then have a seperate sheet for each account code. I want the information contained in cell A2 in every account code sheet to be pasted into the summary sheet next to its corressponding account code.

I have around 100 account codes so i don't want to keep clicking back and forth to each cell in every sheet, does anyone know a shortcut where basically i can just fill down and it looks at the account code in column A then goes to the sheet with that name and then gives whatever is in cell "A2" in that sheet into column B?? or some vba code that might work??

thanks

 

[chiello]

Sorry to Nimrod and HalfAce, but I'd propose a different solution.., that is using the formula.

nickels, enter the formula below in cell B1 of summary sheet, then copy down:

=INDIRECT(A2&"!$A$2")

POst for feedback

Cia o

 

[nickels]

Chiello

Thank you very much, it worked perfectly. Strange how no matter what you do in excel there always seems to be a simpler answer out there!

nickels

 

[HalfAce]

That's certainly the case for me most of the time!

Nice one chiello.