Hi AB33,

I apologise, I realise that by providing only one page in my sample workbook I've made it confusing about what I'm attempting to do.

I have attached a new sample workbook with three pages and the summary page.

Your formula presented the data exactly how I wanted, thank you very, very much , but I'm not sure it will work for the repeated sheets/employees.

When I was talking about inserting rows, as you can now see in the new sample workbook, I need to insert new rows for the data to prevent it from over running employee's further down the sheet.

Thank you again for your amazing help ^_^


Sample workbook.xlsm