Macro to copy paste and sort data

[Burt_100]

I have attached to spreadsheets, The one named Reminders is the main sheet which gets its data from the sheet called Example reminders, Basically the way that the current macro works is when run it asks the user for the date which then calculates the week that the reminders relate to and then it asks for the file name which the user navigates to and selects the file "Example Reminders", The macro then copies the data & pastes and sorts it. I have aquired code to search the Service Due & MOT due sheets for duplicates and paste the data into Service&MOT but the code just does not work correctly - Can anyone help me out with this?
Many Thanks
Johnny