Displaying Data from multiple worksheets into a master workbook

[jackee96]

Good afternoon,

I have read over many of the posts discussing this topic, however I can not seem to apply it to my own problem. I am very new to macros.

I have a workbook containing many different worksheets, I would like to condense some of the data onto a new workbook. I would to create a column with the tab names from each worksheet.

I would also like to pull data from the sheets. Sheet 1 through Sheet 100 have data located in the same cell, for example R6. I would like this to be displayed in a column, next to the cooresponding tab name. The worksheets will not be open when viewing the master workbook.

If you need more information about what I am trying to accomplish please let me know.

Sincerely,
Jackie

[jomili]

I think this will do what you need. Just insert a blank worksheet in the front of your workbook and run it. Change the range as you see fit.

Please Login or Register  to view this content.

[jackee96]

Thank you, that worked perfectly! I never understood how to adjust the code, this simplified it for me.