Copy a range of data and paste to multiple sheets using "User" as key identifier

Hi Guys,
I am a macro novice and I am having trouble finding a way to sort a large data set by User and then select all of the data for that user and paste into their own sheet.
I have 6 different users to differentiate from:WDC_RFGUN_1, WDC_RFGUN_2, WDC_RFGUN_3, WDC_RFGUN_4, WDC_RFGUN_5, WDC_RFGUN_6.
I have 6 sheets named: RF1, RF2, RF3, RF4, RF5, RF6.
I run a report every day that gives me transaction data for the said users and I paste this data set into sheet RF1. The full data set is never longer than 5000 lines, but the number of lines per user each day can vary as this shows actual work done by an individual.
I sort the data by User and then I cut and paste each users data set from sheet RF1 into their respective sheet, where I have a number of macros that calculate work rates.

Does anyone know the code that would automatically cut and paste the user data into the correct sheets?
I tried recording a Macro and I manually cut and paste the data. When I re-ran the macro it worked perfectly for the current data set, but when I ran it the day after with a brand new data set it cut and pasted the exact number of cells rather than user specific data.

Below is a small sample of my data set...please note that I said the data set can be a maximum of 5000 rows. There are 8 columns in total which never changes.
Just to confirm; I want to cut and paste all of the data for a specific user (all the column data), not just the user name.

SCREEN SHOT ON LINK BELOW
Data Set.png

If anyone could help this novice it would be most appreciated.

Does anyone know the code that would automatically cut and paste the user data into the correct sheets?

The code would have to written based on your sheet names, where the data is etc. Pictures aren't much help because there is no data that can be copied from a picture into a spreadsheet for testing.

You should post your spreadsheet so that the coding can be done on the actual sheet. A copy of the sheet is okay. You don't need thousands of rows of data, but you do need some. You can use dummy numbers, names etc for any sensitive data. You've already shown some data in your picture so obviously that data isn't sensitive.

ViewPic.