OK, got it. Thank you very much.
There are a lot of duplicate sheet names in Column F so I assume you want these filtered and copied into these same named sheets.
I would not think that if you have for instance 20 times a sheet in Column F that you want to copy one row and print, copy the next row and print and do this for all 20 times that you copied data across. In other words, you only want the sheets saved to a pdf file once when we've looped, or filtered, through all of Column F
Do the existing data need to be deleted first. From your code it looks like just add it to the bottom and print. Is that right.
Let us know if my thoughts are as you need it done.
It is bed time here now so it'll be tomorrow.