Getting info from other tabs in worksheet based upon cell info for what tab to use

[Turbo68]

I know that I probably need INDIRECT function but cant get the formula right. I have a multiple tabbed workbook and the tab name is a 4 digit number. Like 1234. I have data in that 1234 tab that I want to have show up in another "master" sheet. My 4 digit numbers are in A2 thru A72 so I need my formula in B2 to look at A2 to see what tab to use and to give me a specific cell result from that named tab sheet back into B2. SO if i wanted to get the contents of B1 for tab 1234 how would i get that?

 

[Scott T]

Excel 2010
	A	B
2	1234	7
Sheet4

Cell Formulas
Range	Formula
B2	=INDIRECT("'"&A2&"'!B1")