Multiple VBA Copy data functions from one excel workbook to another based on date and data criteria on macro button push

Trying to run multiple reports off of a button push that filters data by date and then copies the data depending on criteria. So attached is "Book 1". It has 3 Sheets. A "Tasked" sheet that shows what work orders have been given to employees, a "Total Tickets" sheet that shows all work orders that have been received, and a "MACRO" page with date ranges for the 3 ways I'm trying to filter the data and buttons to use macros after dates are inputted. I also attached "Book 2". It also has 3 sheets. "NOT TASKED", "TASKED AND NOT COMPLETE" and "TASKED AND COMPLETED". In Sheet 1 I am trying to pull data from "[login to view URL]) based off date but also comparing data between two sheets- Tasked([login to view URL]) and Total Tickets([login to view URL])- for duplicates in the TASK ID Column and only pulling rows that are not duplicates. In Sheet 2 I am trying to pull data from [login to view URL] based off date but only copying rows that do not have any data in the "Completed Reference Number" Column. In Sheet 3 I am trying to pull data from [login to view URL] based off date but only copying rows that only have data in the "Completed Reference Number" Column. Lastly I would like to figure out a way to clear the sheets in "Book2" every time before the macro copies data over from "Book1". I have Book2 Set up to what I want it to look like after the macro runs. Cheers