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

[yabi100]

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. I want the tables for next 3 years to appear in the bottom of the first year table. I am using excel 2016

 

[Skovgaard]

If I understand correctly, it sounds like you just can use the "From Folder" function, see below.
I normally use this, if I have all transactions from separate years, in separate files.

/Skovgaard