=INDIRECT("'"&D208&"'!E10")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hundikoer" wrote
in message ...

Hi

I have a question Iam not able to find exact answer and my excel skills
are not very high-end

So, I have a Excel document that has Main worksheet and several
(inreasing) number of worksheets, named by customer. I would like to
get information from each customer worksheet to main sheet, but the
source worksheet name should be indirect and recived from main sheet.

I have tried several versions

=INDORECT("'" & D208 & "'!E10")
=INDIRECT(D208 & "!E10")

etc...

where D208 is name of company (also name of the sheet data should be
captured) and E10 cell of cource sheet


Can anyone give me correct direction?


Regards
Hundikoer


--
Hundikoer
------------------------------------------------------------------------
Hundikoer's Profile:
http://www.excelforum.com/member.php...o&userid=28301
View this thread: http://www.excelforum.com/showthread...hreadid=478715