Collecting Data from Separate Tabs

[NatCooper]

Entirely new to VBA but believe this can be accomplished somehow: I have 3 tabs of data which contain the same column names but not in the same order (i.e.: Tab 1 has Student Name in Column A, Tab 2 has Student Name in Column C and Tab 3 has Student Name in Column X). Each time that the data is dumped into these separate tabs, the number of rows will be different but the Student Name will always be in the same column.

I want to copy and paste the columns of data (minus the header) from the mentioned tabs into Tab 4, with the Student Names collected from the other tabs always loading into Column A. I want the Student Names from Tab 2 to be pasted directly underneath the row where the Student Names from Tab 1 ends. And the student names from Tab 3 would then be pasted directly underneath the row where the data from Tab 2 ends. Thank you in advance!

 

[hiker95]

NatCooper,

Welcome to the MrExcel forum.

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?


Can you post screenshots of the actual three raw data worksheets?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
1. MrExcel HTMLMaker20101230
https://onedrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

Installation instructions here:
http://www.mrexcel.com/forum/board-announcements/515787-forum-posting-guidelines.html#post2545970

2. Excel Jeanie
Download


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.