Could some kind person assist with this?

Main data on a range is split by macro into several worksheets and each
worksheet get named as the result of the filtered split (i.e. if column A of
main data is entered with various rows cat dog rat there will be worksheets
called cat dog rat containing original rows from main data
sheet.
If say another data line is out into Main data sheet with column A cell
called Monkey a further running of the macro is needed that adds another
worksheet called Monkey and so on.

It is required, as next step, to total each of the worksheets putting a
double underlined total box with light grey shading .

Then open another worksheet called summary that lists each total row from
each of these worksheets with that all totalled.

It is beyond my experience but would appreciate some code in order I might
make it an example to then by trial and error learn to adapt my recording of
macro's as a beginner.

Your help or ideas is appreciated greatly.