Excel macro, VBA

Need to create macro, which will take pasted data(every day new) and will sort it in desired structure for further use as historical data 1. Every day, except weekends, sheet "data update" will be updated with new information with same structure ( columns). Previous day will be deleted and new day info will be pasted instead of it 2. After click on "Update" button on "data update" sheet: A)It needs to update Pivot tables on "per state" and "per state(days sitting)" sheets (I did it with refreshAll function, you can left it be like that) B) Newly pasted data should be added as values to next empty column at "backend" sheet with matching to TrL CD column, which will be static. At the top of that data would like to have date, at which it was pasted, so when I will need to, I would be able to search historic data and compare them. TL'DL "backend" should save everyday historic data from "data update" sheet so it can be viewed as records sheet to compare performance. (not required, but will tips for that)3. Macro will need to group pasted in "backend" data, so it would be easier to navigate; create table which will automatically add last record data to its column. let me know if you have any question, can schedule google meets so we can discuss it more