Need some help here.

I have two sheets: 1. GL download 2. AP download
There are different number of columns for each sheet.
Some of the columns do overlap.
I want to compile the data into one sheet. I do not want to sum. I want the VBA to pull in each row.

For example, GL download tab has following headers:
Date
Description
Amount

AP download has the following headers:
Date
Description
AP Amount

I want the third sheet to pull in Date, Description and Amount from GL Download and AP Amount from AP Download into the same column.

Can this be done?

I know it'd be easier to just rename the column. But to complicate things a little, there are different number of columns in GL and AP download and they're in different order too.

Thanks!