Macro Issues

Hello,

It has been awhile since I have used macro's and I am running into issues. I have a macro set up to sort the data how I want. It highlights dates in the next week in red, sorts the 3 columns needed by dates. I have all the macros made under separate macros that run under one final macro. My issue runs into when I try to replace the data that the macro was made with. I need to be able to past in new data on a daily basis, and run the macro to sort it how it is needed. Is that possible to do or am I doing something wrong that it gives me an error and does not end up working out how I need to.