VBA code to copy data from tables on different worksheets and put them in one table

[jonnysamuel12]

Hi,

I have 3 tables in 3 different worksheets. I want to setup a Macro to copy and paste the data from all 3 tables into another workbook (pre-existing), pasting one below the other and keeping the set of headings from the first table.

The headings of the 3 tables are all identical.

The number of rows in the table will change every time I use this Macro as data is constantly being added to these 3 tables.

So let's assume:

Sheet1
Table range:
- columns A:C
- rows: currently 1-5, but could be longer

Sheet2
Table range:
- columns A:C
- rows: currently 1-5, but could be longer

Sheet3
Table range:
- columns A:C
- rows: currently 1-5, but could be longer


I'm new to Mr Excel so forgive me if I've written anything incorrectly.

Really appreciate anyone who can help.

Happy to answer any more questions if need be.

Kind regards,

Jonny

 

[starl]

There are many existing example of this at the board if you do a search. Like this one:
https://www.mrexcel.com/forum/excel...s-into-one-master-data-sheet-please-help.html

Very similar to your request.