Cell value to reference tab name in formula

[ICKIER]

I hope I titled this correctly...
I have 10 tabs with data and 1 tab I want to print from that references data from the other tabs.
I would like to type the tab name to reference in cell A1 so that all the formulas "know" which tab to look at based on the value of A1.
I believe I use =INDIRECT but can't figure out the context.
Example: If I type RED in A1 then the formulas know to look at a particular cell in tab RED. And instead of manually changing all the formulas if I want to look up data from tab BLUE all I have to do is change cell A1 to BLUE.

 

[AlanY]

A1 is the tab name and A5 the target cell

=INDIRECT(A1&"!A5")

 

[ICKIER]

Don't you like the EASY ones, AlanY?! Thanks!

How about if B2 is last name and A2 is first name, how can I merge the two in one cell using INDIRECT?

 

[AlanY]

just join them together

=INDIRECT(A2&DA1&"!A5")