Looping through excel files with slightly diff column headers, consolidating into one file

[teeefarnee]

Hi, 

I have multiple excel files that look like this:

Eventually I just want to output it to an excel file like this - with the years mapping to the correct column header

The data is all stored in the same sheet in the different excel files, just that the years might not be the same (eg. some might start in 2021, 2023 etc) and I want to map it accordingly. attached is an example of the excel file :( appreciate any help i can get!

[Qiu]

@teeefarnee 
There is a Macro to import multiple sheets with different schema by @mceleavey and I made some modification.
Please make some necessary adjustment to the macro for real data.

[teeefarnee]

Hi! thank you for your help - im very new to alteryx, so is it possible if u run me through with me the working;

also, how would i go about inputting different excel files?