Indirect Function Summary Tab Template - Need Help!

[adbcrazy]

Dear users,
I am looking to create a summary worksheet using the indirect function to collect "Prices" from several tabs in the same worksheet.

As I have about 40 workbooks to do this for, I want to create a Summary Template I can copy and paste into the other workbooks:
As seen in MrExcel # 681
http://www.youtube.com/watch?v=lgwc81fRSP4

The only problem is I cant get it to work>? Its probably something very simple but i've missed it.
Can anyone help me?

=INDIRECT($A$4&"!Cell(""address",C55)

Where:
A4 - is the name of the tab I want the price data from (no spaces)
c55 - is the cell(with the price in it) I want to bring to the summary sheet

Thanks in advance,
Andy B

 

[Special-K99]

Untested but try

=INDIRECT("$A$4!"&Cell("address",C55))

 

[Jonmo1]

Welcome to the board...

try

=INDIRECT($A$4&"!"&CELL("address",C55))

 

[njimack]

2 options...
=INDIRECT($A$4&"!C55") or =INDIRECT(ADDRESS(55,3,,,$A$4))

 

[adbcrazy]

Untested but try

=INDIRECT("$A$4!"&Cell("address",C55))

No it didn't like that and brought up a #Value error
and recommended to change it to this:-

=INDIRECT("$A$4!"&CELL("""address",C55))

 

[adbcrazy]

Untested but try

=INDIRECT("$A$4!"&Cell("address",C55))

=INDIRECT($A$4&"!"&CELL("address",C55))

This worked!

Cheers Guys! - ur all awesome!