Macro on multiple sheets - grouped sheets

I have a file that contains about 15 worksheets. Each sheet contains a chart that has the same number of rows and columns. My daily job task requires me to edit the chart by deleting rows, columns, and changing widths of columns for each worksheet I am responsible for. The fastest way I know how to do this was by grouping the sheets and then editing one of those charts on one of those sheets, and when I do this, it automatically formats all of sheets/charts at once. My question is this: is there a macro I can create to edit all of the sheets at once instead of me selecting/grouping the sheets first, then manually editing one of those grouped sheet's chart each time? I tried to record a macro for the grouped sheets, but when I ran it, it deleted all content of all sheets?

I know if I recorded the same macro on only one sheet it would work, but it doesn't work on grouped sheets. I'm trying to figure out how to do this. Please help if you can.

Thanks,

Stan