Count filtered data in VBA referencing multiple columns in a table

Ok attached is a sample workbook. On the Report page, Generate List is supposed to paste data from the data page of certain columns of whoever is labeled in the Select Manager drop down. My problem is when it is filtering, the mgr= integer is counting all data in the column and not just the filtered like I need it too. I need it to loop through each Level "*" column and paste on the Report tab.