VBA - Creating Master List (from different worksheets)

[johndoe12123]

Hi All,

I'm new the forum and have very limited VBA experience. Would really appreciate ANY help with my issue.

Right now, I have 3 different sheets of data, with different number and order of columns. I need to create 1 master list that combines the data from 3 of these sheets, thought not utilizing all columns across all sheets (i.e. pulling data from 6/10 columns from Sheet 1, 4 Columns of data from Sheet 2, 7 columns of data from sheet 3 etc.).

The column headers on the master list should theoretically be the same as those found on each worksheet.

I've basically created the master list using vlookups, but this was extremely tedious and i'm trying to automate the process in the event of a data update. Would really appreciate any help on this. Thanks!!!!

 

[mumps]

We would need a little more information. What are the names of the 3 sheets and which columns do you want to copy from each sheet? Do you want to copy based on the columns headers? Where on the Master sheet do you want to paste those columns? Please be more specific in your explanation.