need help want to copy one cell from multiple sheets to one sheet

[Masekind]

Hi All
I want a formula not VBA to copy a cell from multiple sheets to sheet 1

[sweep]

You can use the INDIRECT function to achieve this:

In cell B3,

=INDIRECT("'"&A3&"'!Q65")

Note that the sheet name (the Item in Column A) will have to be amended to match the sheet names for this to work.

[micope21]

Hi

B3

Please Login or Register  to view this content.

copy down and cross.

You must have same word to match Sheet1 vs all Sheetlist and B2:H2 vs HH BLUE sheet Q59:Q70

Do not put in like this Cell A3 HH/BLUE vs Sheet HH BLUE, this will become #N/A!! Both must be same like this HH BLUE vs HH BLUE.

See the file.

Regard