Format data and split unique criteria to new file

Hi,

I was previously helped out with a code here which would split the data into new files based on a unique PC number:

HTML Code: 

But frustratingly the original requirements changed and I am hoping someone can help amend the existing code provided to achieve what I now need.

Requirements

On the attached I have three tabs.
1. This is the raw Data
2. This is the layout requirement for the raw data (only it would be split by PC number)
3. This is the old format of the data for reference only

The following is what I need:
1. I no longer have header rows 1:5 so this requirement has now gone. (Only the first row needs to be retained)
2. Column B is now the column to be split (to create each new file)
3. Columns A:E need to be deleted (so I am left with just three columns as shown on the tab TB load Format)

Can anyone assist please?

I have uploaded an example with the original macro included.