To Copy some Details of Sheet and paste in different Sheet

Hi, Everyone.
Do you have idea on this , I want to copy details from source sheet into Next sheet

.

Every details is separated by Total.

Can you explain please how will you group the data.

may you please highlight all the group in the image you have provided

From source file “CCN SALE REPORT”

I want to copy the details of each contract# based on Store (separated by Total) and will automate depending on store provided on the sheet to another tab (tab name will be the specified store)

Do you have idea on how to group the data per store?

From source file “CCN SALE REPORT”

I want to copy the details of each contract# based on Store (separated by Total) and will automate depending on store provided on the sheet to another tab (tab name will be the specified store)
Do you have idea on how to group the data per store?

Hi everyone, Any Help ?