Macro for filtering raw data,copy/ pasting and sorting based on conditions

Hi All,
I have a tedious sheet that I am trying to get off the ground and had a go at using the auto macro walk through but just couldnt get things to click. I am trying to create a sheet whereby I can prioritise maintenance work orders based on certain criteria. A basic step by step of what I am trying to achieve is below;

1) User dumps raw data into tabs nominated with "Raw"

2) Click a button on the front page that will sort all the raw data tabs into their corresponding "priority" tab with the exception of the "safety priority" tab in which I need to filter the "Work Order Type" heading for "SA" from each raw data tab and place into the "Safety priority" tab
2a) A condition of the sheet filtering to the different tabs is that it must check to make sure that no existing data exists already in the priority tabs with the same "Work Order" column data. eg. when the sheet updates it doesnt overwrite any existing data with the same "work order" number, it simply adds the new work orders below the existing data in the tabs it was filtered into.

3) The sheet will be updated weekly with values in the "original priority" heading for any new entries (1-5value). The "current priority" needs to be set on a condition of the original priority such that 7 days from an original priority of 5 the current priority changes to a 4 and so on each 7 days until it hits a 1. Once it hits a 1 and the "date raised" tab is < todays date the row needs to highlight red. However if there is data in the finished date field the condtion should change to a green row.

4) The priority sheets also need to sort the current date from lowest to highest with a button on the front page also

I hope that makes some sense, I can do a fair bit of 3) but its really the other stuff I am struggling with. Can anyone help me out or get me in the right motion with a macro on this please?