Need macro to print & filter columns

[fobioha]

I'm looking for help with a macro that filters Column A based on a list of cell values (for example filter to only show Loo, J.) and then collapses the columns that don't show any number values, then prints to pdf. Please see the example file https://www.dropbox.com/s/68grpnkngj...mary.xlsm?dl=0

Any help would be much appreciated! Let me know if you have questions.