hello,
i need to copy data from column B and C from sheet "JanFebMar" to sheet "Q1". Names will be entered manually or via the dropdown lists in cells b3:c36 on JanFebMar, and I would like them to copy automatically to Q1 columns A and B. If a name gets entered more than once on JanFebMar, I only want it to show up once on Q1. I have attached a sample. Can you help? Thanks!

sample.xlsm