Excel If function Without Empty rows

I have Sheet with schedules of the customers and date for delivery but i have couple sheets like that. I want to create a calendar that brings all the sheets together, so We can see everything in the calendar on the appropriate date. I am using this code. =IF(CURRENT!H20:H117=E1,CURRENT!B20:B117,"") problem with this is, this works only on one sheet and also when it prints on the calendar I have a lot of empty rows. I am basically looking for a better idea to approach this or a fix for the above code. it jumps rows because where it gets the information does not have the same dates.