NICE TO HEAR FROM YOU AGAIN.
A duplicate record is one that is identical to another. All cells in a row matching all cells in another row. I have about 5000 records (rows of data) and it was very difficult for my feeble brain to remember that I captured the data for a record previously. The consequence is that I find that there are dupes.

Yes the records can be sorted to have the dupes grouped...
but manually removing dupes is like picking fly poop out of pepper and subject to missing some. Macro is a quality control measure.

After eliminating the dupes from the main sheet, the eliminated records to go to the dupesheet. ie...a record "aaa" might show 3 times. Maintain the original worksheet with one record "aaa" and the other 2 to be sent to dupesheet.

I know there are dupes. The macro will be a one time deal to get rid of those dupes.
Any subsequent revisions to the data will be seldom and magnitude of changes quite simple to manage.