Copy worksheet names into summary sheet

[heathercoldsmith]

Hi,

I don't actually know anything about programming in Excel, but I have someone helping me so I'm trying to gather the info he will need to be able to do what I want him to do.

I have workbooks containing sheets which each contain data of the same shape and size (i.e., 19 rows and 60 columns). I want to create a summary sheet which consists of row 19 from each sheet, but I want column A to contain the name of the worksheet the row was pulled from.

I found this page, which I believe will take care of pulling the rows from the sheets, but is there a way to get the sheet names in column A?

Thank you!
Heather

[Mordred]

Hi Heather,

Try something like the following

Please Login or Register  to view this content.