Help Automating Spreadsheet

All of the instructions are highlighted in the spreadsheet. I figured it would be the easiest way to keep this simple. I need help automating this spreadsheet. I have a report that I generate everyday and then I would like to past the contents to this spreadsheet. Then have that data copied and sorted to next sheet. Then based on specific criteria I need other parts of the data transfered to correct sheet. I know this would be easy for many of you, but I have no experience with VBA or macros. I plan to looks at the training material thread while I am here. Any help would be greatly appreciated.Nov29 DEMO - Copy.xlsx

Can it be set up for me to paste new information in the raw data sheet and will it automatically transfer the required information. I am not trying to change the actual appearance of the spreadsheet because others will have to use it and I have to do this with their templete.