how to use a query to import or append others years table to end of first year table?

I have 4 excel files, each file gives sales data in one sheet for a specific year. Year appears only in file name. I want to make a dashboard to show data in different ways. I made a query to edit the data, namely get only needed columns, add a column for year. I did all of this, for the first year. Now I want to know how can I use this query to apply same edits to other files? I assume the query I build, can do this, but I don't know how. Later, I want the tables for next 3 years to appear in the bottom of the first year table, totally to become one table so that I can build my dashboard.

Thanks Sandy.
I hadn't been around for years. Updated my profile.