Loop thru Dropdown Arrow in Celll B2 of Sheet "Test"

[MikeL]

I have a list of Presidents in B2 with a dropdown. I would like to loop thru dropdown in Cell B2 of "Test".

Then copy contents from A1 to end and paste in new sheet for each change in filter ie called "Test_Washington" , "Test_Kennedy" etc