Summarising large amounts into tables on a new worksheet using VBA

Hi everyone,

Apologies that the title isn't very descriptive, there are just so many factors that my very basic skills do not even nearly extend to so I really hope someone can help please?

I often receive large spreadsheets of data and have to make summary tables on a new worksheet of this data to give to my boss (so ideally would be formatted nicely so I can give it directly but that is the last of my worries!). We receive these regularly (I have done one each day for the last week) and as my excel skills are slightly more advanced than my colleagues (in terms of I can use vlookup formulas so nothing major!) they generally all get passed on to me!

Ok so what I have to do/need:

Add a new worksheet called "50 GRPs".

As the data needed in the table can change each time, in an ideal world a userform would pop up with all of the headings found checked and the user can deselect what they do not need in the summary table.

For each Name found in the Brand Name column, I need it to go down the column named "Actual Main GRPs" and read the value closest to 50. Once it has found this I need it to read the values from that row and put the values from the columns selected in the userform (along with the column heading) into a table in the new worksheet.
I need it to do this in 50 increments and then take the final value.

I need it to have one table for each name found in the column Brand Name and for the table to be called the Brand Name and also quote the "Main Target".

The column headers won't always be in the same order or have the same name (bar the column headers "Brand Name", "Main Target" and "Actual Main GRPs").

I really hope this makes sense and someone is able to help me out as repeating this over and over is beginning to drive me a little mad! I would REALLY appreciate any help offered. An example of the finished workbook is attached - I have left in my previous workings with v-lookup but obviously the would no longer be formulas and the column headed "Base GRPs" wouldn't be needed.

Many thanks