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?