Macro to take data in one set of columns and break it down into months?

[tonywatsonhelp]

HiEveryone,

I Hope this is clear, trying to move data around to get monthly data?

So In pull my raw data in one big list in sheet "raw data" Columns A to H

Columns A to E are Customer data,
Column F is the Month,
Column G the Category
Column H the Amount

So heres what I want
In Tab "Sorted Data" sarting a column A,
To make a list of All clients with their information (so from "Sheet Raw Data" Columns A to E) using A to remove duplicates.
Then in Pull the amount for each client for each month into the columns in F onwards.
So there is a date in column F1 for example so look at raw data find Client name in column1 month in Column F and pull that data in.

I hope this makes sense?

Thanks

Tony