Macro to Group, Label and draw borders

Hello all,

On the attached example, I would like a macro that makes sheet1 look like sheet2.

The rows need to be grouped by the load data (Column A). I would then like a column inserted to the left of this that is merged to create a vertical label for all rows with the same load data (as shown in sheet2).

Once this task has been performed, I would like borders to be drawn around all cells and then a thick border drawn around the grouped, load data.

The number of different loads and rows of data will vary each time I run the macro.

I have no experience on creating macros so any help is greatly appreciated.
thanks,