Find missing names in table from list and add row

Hi all

Please excuse the title i always have difficulty expressing my problem in a few short words. I have a list of names in sheet 1 and in sheet 2 I have a table comprised of data next to these names appearing in the same order as the list though often with duplicates. After i apply a filter (in the example attached it is FALSE) only the rows with TRUE remain visible and as such i lose some names( in the small expample sam and sonia). What i would like is code to search for the missing names in the table and in that event enter a row (maintaining the order of the list) with the mising name sam in the example A17 to reappear though with all the data deleted (this is important for later calculations). I apply the filter by the vba in the example. The hidden data is irrelevant aed and can be permanently deleted if necessary in fact that would be desirable all i need is for all the names in the list to be present in the table in the same order. Those that have been filtered to be present though with no other data in that row. I do not want all filtered names to reappear as in this example one instance of DAvid has been filtered though as he is still in the table that is not important. Finally to reiterate just ONE inserted row with name and no data for those that are missing.

sorry for the novel i hope I have been clear.
Regards
Dan