Find most recent date in Column Headings in a Range, insert new column and heading

This is the actual workbook I am using. I was thinking of changing the headings in any case for ease and clarity. Whatever is easier I can adapt the headings. Thank you