Macro to pull data from several other worksheets + sort

Hi,

Having some trouble here. I have 5 worksheets that summarise data from other worksheets. I want one final worksheet to include data from each of the 5 worksheets. The 5 summary sheets include "Code", "treatment week", "No of goals", "No of goals with 777", "no of goals excluding 777s, and 888s", and "average excluding 777s and 888s".

In my final summary sheet I would like:
Code (taken from each sheet)
Client or Partner (info can be taken from the worksheet name, if C_XXXXX then client, if P_XXX then partner)
Treatment condition (info taken from worksheet name, e.g. C_PA-CBT, where C is Client and PA-CBT is the treatment condition)
No of weeks completed of treatment (e.g. if there are 6 repeats of the code in the same sheet, then it will be 6 treatment weeks completed)
No of Goals for a specific treatment week (1, 2, 3, 4, 5, 6, all separate headings)
No of 777s for each week (same as no of goals with 777s)
Average for each week (same as average excluding 777s and 888s)

How on earth should I do this? Just some guidance for what to look into would be helpful so I can read a little more about whether it suits and then specify my question further.