Your spreadsheet must be different than what I understood from your original
email. To create dummy data  for developing the macro, I entered Consultant1 in
A3 on a blank sheet. I entered Current Period in B3 and Quarter To Date in B4.
Then I selected A3:B5 and used the fill handle to copy  down through row  32,
giving me headings for Consultant1 through Consultant10. I put even numbers  in
the Current Period rows  and odd numbers in the Quarter To Date rows. Does that
resemble your spreadsheet? With or without the blank row between sets of
records, the macro  gives me exactly the output you described.

MT is a counter. When it accumulates a count of 10 contiguous empty cells in
column B, the macro stops looping. Since you said the number of consultants may
vary, this is a way for the macro to know when to quit.