Copying data from other worksheets to a master worksheet

[sa1ntj0hn]

Hello. I was wondering if anyone was able to assist with the following.

I have a workbook that contains a Master sheet and numerous other sheets that are all in the same format.

I am looking for a macro that will read the values from each of the worksheets and paste them into the Master sheet.

In the attached example, the master sheet has a column for each of the following "Sheet name", "Value 1", "Value 2" and "Value 3"

Underneath these headers I need the values from worksheets Alpha, Bravo and Charlie populating in a list.

Hope that makes sense.

Phil

[BadlySpelledBuoy]

Give this a try:

Please Login or Register  to view this content.

BSB

[sa1ntj0hn]

Got it to work, thank you. much appreciated