Macro that reads several files in a folder

[Real_Noob]

Hi,

I need a macro that can

1) Open up a file located in a specific folder
2) Mark the data that is shown (e.g. not the data that is filtered away) and copy it. Such as the data in the "Example Data" sheet.
3) Paste it in a new sheet. Such as in the "Example output" sheet.
4) Open the next file in the folder and do step 1 and 2. Paste the data below the data from step 3. Re-do this untill all files in the folder are in one sheet.

The selection criteria has to be the filters that are chosen in the Excel. It is not possible to find the selection in any other way as it is a manual process.

Thanks