Refernce list from seperate sheet and exclude blanks

Hi Guys,

I have en excel document that references a schedule produced every few days in the same format. I need excel to reference a list when the schedule is drag and dropped into a sheet. However i need it to remove the blanks in the list,

I'm using this formula, but it doesn't work when referncing the sheet "Tr7" list E7:E57, and return to active sheet A15:A65


IF(ROW()-ROW($A$15:$A$65)+1>ROWS('Tr7'!$E$7:$E$57)-COUNTBLANK('Tr7'!$E$7:$E$57),"",INDIRECT(ADDRESS(SMALL((IF('Tr7'!$E$7:$E$57<>"",ROW('Tr7'!$E$7:$E$57),ROW()+ROWS('Tr7'!$E$7:$E$57))),ROW()-ROW($A$15:$A$65)+1),COLUMN('Tr7'!$E$7:$E$57),4)))

No idea why this doesn't work, i've tried creating names for ranges also