Consolidate data from svral worksheets into 1 with 1 column row wise, and rest column wise

Hi guys,

I am attaching a sample file with instructions for your ease.

I will really appreciate if you can help me out with this.

Thanks a lot,

I quickly tried it in a new datasheet with new sets of data, and it is working well.
I will give it more thorough testing later, but thanks a lot.

@ Hello23

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Hi, the code is working very well, but there is one issue.
Each time I make a change to a sheet named @____ the master sheet
adds a second set of data from all the sheets. So basically I have to
clear the contents of the master sheet, and then run the code again,
then the data doesn't appear twice, but just once with the changes made
on the @____ sheets.

Is there a better way so that the master sheet automatically updates the
data correctly without me having to clear contents, and then run the code again.

Thanks.