Merge excel files to one meanwhile a new column indicate year and month

Each month, I have an Excel file with a filename such as “ARaging202401”, and the format of these files remains consistent each month. Now, I need to merge them into a single file and add a new column named “month-year”, where the content of this column will indicate the corresponding year and month of each original file.