Merging 3 seperate tables into 1 master table

I am creating a base to track my inventory,

I have created 3 locations in 3 seperate tables, with images description etc.

I would like to know how to merge all 3 together into one table (master table)

Is there any way I can do this with data intact?

You can export the data, and then re-import using the CSV import app.