Hi,
I have a workbook with 31 sheets (diary)
A9:F9 (and other rows) is the info I want with the employee's initials in G9
There are multiple entries for the employee so he may reappear in row 13 and
15

I want to pull all the lines that relate to that employee from the 31 sheets
into a separate workbook

Thanks