Consolidate Multiple Work book to Master

[kannan1847]

Dear Team,

I have 4 sheets Team A, Team B, Team C, Team D with same heading in sheet one

My need it consolidated to master work book sheet one by one

I attached Sample file and desired output in master sheet.

pls provide button to consolidate to master sheet.

[Richard Buttrey]

Hi,

If you only have 4 workbooks and unless you are wanting to do this repeatedly then just do it manually as you have done with your example.
And if you do want to repeat this are you sure you need to capture the data in four separate workbooks? Why can't you capture it in a single workbook?

[kannan1847]

It is received from 4 teams and number of team may increase upto 20 and every time we consolidate we not want to copy paste so VBA button is best

[Richard Buttrey]

What was the answer to my last question?