Why do you want to do this?

Do you want to abandon working and easily manageable design with one, where different data groups are on different sheets? Which will be a headache, when you need e.g. some total overview. And you have to redesign your workbook every time some new grouping is applied.

Or you want simply to display data of single data group? Then design a report sheet, where at top of sheet the user can select (using Data Validation List) any data group identificator (e.g. "AGS" for your example) , and in table below all wanted data are displayed from main table. To do this, you either:
a) use an ODBC query in report sheet, with cell where user selected the group identificator as WHERE clause parameter, and which will be refreshed whenever a new data group is selected;
b) have the table on report sheet with formulas, which determine the row in main table to be read into report table row (e.g. by adding hidden columns into main table, where the row number of main table, and the entry number of any identificator you use, are calculated) using e.g. SUMIFS function, and then use INDEX function to get all values from this row in main table into row of report table.

With either of solutions, to display certain group of data, you need only 2 sheets! And whenever you add a new data group to main table, all editing you need is to make this new group to be included into Data Validation List on report sheet!