Changing Data Source When Column Headers Are Different

Hi,

I have created a dashboard which shows us the monthly sales. For example for the month of July, column headers will be Sales July 2021, COGS July 2021, Sales Forcast July 2021 e.t.c. So when I try to change data source so that I can import the data for the month of August, I get the error,

The column headers for the August data will be Sales August 2021, COGS August 2021, Sales Forcast August 2021 e.t.c. The monthly data files are in Excel.

I would manually change the column headers but I have 62 column headers that I will need to change on a monthly basis which is time consuming. Is there a workaround to this or an easier way or am I doing something wrong?