Extract Group of Excel chart to PPT Slide and put a header for that group

I was thinking about writing the code - when using chart objects we tend to loop through the objects that exist on the worksheet. With this in mind how would we know which chart belongs in which group?

It could be the chart name?

I imagine your data to be all in one worksheet with a row as a header with 6 charts underneath - then another header row with 6 more charts underneath etc...:
If the above is the case then we can't group by those headers but if the charts were named differently per group or each group was in it's own worksheet then this would be a simpler task.

Thanks for your time.

We could use the chart name or we can mention the range in which the charts are there and loop through that to see the objects?

If you think having different sheets will be a better solution we can go with that too.

Also is there a way we can have the 6 charts grouped together and then copy that group in PPT slide and mention the header above that?