Copy Multiple sheet data into Master sheet using VBA

I have four Sheets with the below info:

Worksheet 1:
A1: Name B1:aaa
A2: Place B2:bbb
A3: Animal B3:ccc
A4: Thing B4:ddd

All the sheet has only two column of data and Column A has heading in four rows. Only the column 2 changes in each work Sheet.

How do I get this into the master Sheet with each sheet info on next column. Please See below what I want

A1: Name B1:aaa(from Sheet1) C1:asd(from Sheet2)
A2: Place B2:bbb(from Sheet1) C2:dff(from Sheet2)
A3: Animal B3:ccc (from Sheet1) C3:cjd (from Sheet2)
A4: Thing B4:ddd (from Sheet1) C4:tyu (from Sheet2)

etc. Can you please help. Thanks!

Hi Please see the sample excel file here.

Hi Thanks for this... It works great! However need a small tweak.

If I change the worksheet names it is not working. For eg: if I change the name of 'Sheet1' to 'Sheet5' it is not working. Can you pls help me with code that will work with any sheet names. Thanks a lot again for your help!

Originally Posted by arlu1201

Will the Master tab already have column A populated or should it be done by the macro?

Hi Arlette, I can copy column A and paste. If other columns are pasted that would do for me!

Try this one

Please Login or Register  to view this content.

Thank YOu - This is working great! exactly what i wanted:-) Have a nice day.

Originally Posted by AB33

If you wish to copy "A"

Please Login or Register  to view this content.

THis is not working as good as the previous one. It copies Col A to all other column... Not the data.

Vathsan,
You are welcome!
Please close this thread as solved. Go to the top right hand side of this page, choose, solved from the "Thread Tools" drop down menu.