Continue to find the data in the table until end | Excel forum

Hello,
could you please help me with a vba question. I have written a code which it will go to the tab per row a, then look for the library (data) per column a, and highlight the whole row in that tab in color, then filter.
The code works fine when in the tab only have 1 library name. however, if the tab has more than 1 library name, the code only find the 1st one and stop. I want the code to highlight all the row with that data (library name).

Could you please help? what do i need to change in the code?

I want to show you the excel file I have. can i attach file to this forum? if not, please let me know which address i can send to?

many thanks for your help.
Kim