Automatically update filter

Hello,

I have a spreadsheet that has source data on it, i want to copy only the rows that have text onto a worksheet that i'm using as part of electronic signage. what i want to do is copy the data from the source data, paste it into the new sheet, and make sure if it's blank then it shows blank and not 0. However as there's many categories, i want it to hide any rows that if there's no data in column A then it hides the entire row, but also refreshes the signage worksheet when data is input into the signage sheet. The reason we are attempting this is to make the data fit on the screen and display nicely.

I've managed to get the copy bit working using the formula ='[TODAY (2) (002).xlsx]Today'!A3&"" so that transfer the data over and hides all the 0, i added a filter, but the filter doesn't refresh when i add information into the Today sheet and i have to manually refresh the filter. as it's going to be on a rolling display i was hoping a macro or something easyish could be done to make it hide the rows on the display sheet if there's no text in column A.

I have absolutely no knowledge of VBA and I've tried copying code from other sites to put into VBA but it never works, so i have no idea what to do!