sheet with the contents of al the worksheet

[Victor]

i am looking for a possibility to create a sheet with the contents of al the
worksheets that are in the file you are working in.
Input for the sheet with contents would be a specific defined cell (let's
say the content is in Cell A1 of each worksheet) + the name of the tab of
the worksheet.

 

[Pete_UK]

Did you not like the answer I gave you in your identical posting
in .misc?

Please do not multi-post.

Pete

 

[CLR]

Not sure what you want.......maybe something like this?

=Sheet2name!A1&", "&"sheet2name"

More details would be helpful.

Vaya con Dios,
Chuck, CABGx3