Pull data from multiple sheets

Hey all,

Just found this forum and it looks super useful. Apologies if this is in the wrong thread - just had a quick question.

I'm working on a sheet trying to keep track on which client is working with which employee. The first sheet shows tracking for the year and each additional sheet is the month. Basically the Yearly sheet is there so I can quickly control+f "client name" and see which employee he or she is working with.

I attached a simple version of the workbook but basically it basically looks like this: Yearly sheet - Row 1 is the employees name, Row 2 is the month, and the rows after that are the clients name until it gets to the next month. January sheet - cell A1 says client, Cell B1 says employee. I'm inputing the clients in column A and the employee in column B and using this formula for the Yearly sheet (starting in row 3) =IF(January!$B2=Yearly!A$1,January!$A2,"")

This is working for what it's supposed to do, but it's not pretty and leaves a lot of of blank cells. Is there a simpler way of doing this?

YearlyClientsEmployees.xlsx