You don't show what the desired results on the Master should be for the IT and LOG sheets you've posted.

I've deleted everything on the Master except for the first line.
Alt + F8 brings up the macro dialogue, run the macro.

Hope I have commented the macro enough for you to follow and alter as necessary. Depending on what is actually wanted you may need to alter or add to the sorting and/or filtering.

A couple comments to assist with VBA:
Time and dates.... use time and dates. Not text.
Merged cells.... avoid them like the plague.

Attached Files

TRNG SCHEDULE FINAL FORMAT.xlsm (24.7 KB, 13 views)