Hi Guys, I'm fairly new to VBA and need a bit of help. 
I'm trying to make a VBA macro that would remove duplicates from column 1 of previous sheets and scales with how many sheets are in the workbook.
The idea being that as number is entered into sheet 2 (column 1,) it is removed from sheet 1 (column 1)
I can find examples that will delete the duplicates from the same sheets but not others.
Any assistance will be greatly appreciated!

I'm trying to make a VBA macro that would remove duplicates from column 1 of previous sheets and scales with how many sheets are in the workbook.
The idea being that as number is entered into sheet 2 (column 1,) it is removed from sheet 1 (column 1)
I can find examples that will delete the duplicates from the same sheets but not others.
Any assistance will be greatly appreciated!