Can I use a Macro to generate a report for this spreadsheet as attached?

Hi

I'm a basic user of Excel to be honest.

I have a spreadsheet as attached below.

What I'm aiming to do is to be able to simply press a button and for the sheet to generate a report with the cost information sorted per supplier.

So, when you press the button, the cost totals per supplier (see left hand side of sheet).

Is a Macro the best way forward and if so how easy is it to make this work?

Thanks.

Thanks Jaslake - that works well but it'd still be more efficient if I could push a button to make this work in one hit.

I say this as there could be a lot of data and it would be great if, on button push, all the data could be sorted in a report/summary type style.

Any ideas?

Thanks.