I have a table of columns, some titles, others costs.

Think I may need to email the files to someone to better demonstrate it.

Is it possible to create a macro button that will create an additional sheet
that summarises all the headings in column 1 and sums their respective costs

Then another button on the new sheet that will export the data into a
template in their correct columns.

I would greatly appreciate anyone's help