Copy from multiple sheets to one & delete dup

Hello,

I have multiple sheets, all formatted the same. I want to copy column A from these sheets (starting in cell A5 to end) and paste to an existing summary sheet (starting in cells A5). I want to then delete the duplicates in column A of the summary sheet. There are a couple of sheets in the workbook that I want to exclude from the macro as well.

I'm very new to this and not sure whether I should use VSB or a macro...or even what the difference is.