I hope someone can help - I've only been using Excel for a few months and think I've overextended myself! Apologies in advance if I don't make myself very clear.

I have a worksheet for Team 1 which includes weekly intake/cleared and outstanding totals for various categories of work. Using named ranges, this sheet feeds into a second sheet which contains dynamic charts for each category and automatically updates to show the last 8wks data. After far too many hours of my weekend, this now works beautifully!

What I need to do now is produce a further four versions for four other teams, ideally within the same workbook.
I've only been able to make it work by either doing each team in a seperate workbook, or by renaming the ranges,for each team so that I have, for example, "OneTotalClearance" and "TwoTotalClearance" etc.

As I've only got this far by reading previous posts here, I hoped someone may be able to tell me if there is another way of doing this? My solutions seem a bit long winded.
And I hope someone understood this!!