Removing characters from different cells based on contents in a separate cell

Originally Posted by JohnTopley

Another question: are we only concerned with dates in the "base" table i.e "Static Table for reference" ?

If we are to look at all of the 6 other tables, we need to "identity" the date rows in each table: they are either fixed as per your latest sheet with each table of consistent length oor we add a "prefix" e.g "Date" in column F to search for the next block. OR as I proposed earlier, we give each table a name (Named range).

Hope this makes sense!

John - the morning name row may move up or down a few cells in the final version, is there a way to select with a function, similar to what we are currently doing with =getinitials(cell range), thanks