I need some help on a Macro.

I am pulling multiple reports with a variety of different columns and column headers into one workbook-but leaving them on separate sheets-using Macros. I am also trying to get the reports to compare against each other to remove duplicates based on a hierarchy of sheet importance so we don't have people walking all over each other due to similar data pulling for multiple sheets that require different processes.

Is there a way to make a macro I can attach to a button to allow the sheets to filter?

I don't need the code, just a quick description of how it will function or where I can find that type of duplicate removal so I can sort it out.

Thank you!