EXCEL MACRO FOR MAC - NO DUPLICATE NUMBERS ON S/S

In MAC Excel on sheet one, I need someone who can write a macro that filters through a LOT of numbers with duplicates in Columns A,B,C,D etc etc and then the macro transfers ONLY the original numbers from the entire sheet 1 (ie no duplicates at all because there will be a lot) onto sheet 2 of the spreadsheet in columns A,B,C,D. I need to add numbers to this on a daily basis and there are a LOT so I need someone to write a macro that works that I can just keep adding to and running with no fear of duplicates on the master sheet 2. So numbers in sheet 1: A,B,C,D,E,F,G etc etc get filtered into sheet two where only original numbers are (no duplicates) and Fill up Column A, when that’s full column B, and so on so I am left with sheet 2 only containing original numbers.