Until the data is "standardized" there isn't much that can be done for a permanent solution. What I gave you is an adaptable template that retrieves data from your worksheets. If you use different codes in the helper columns, that I used, for each of the two sections it will be relatively easy to retrieve the data in the order entered on each worksheet because this is just a vlookup determined by the worksheet name. The coding for each tab would be the same for each section because only the month and its values will change. The formulae for each section/month will remain the same. All you need is to get your data in a standardized format.

I will keep a subscription to this thread to see what develops.