For Excel, you can use macros or formulas to perform similar tasks.
In the "AGS" tab, create a formula or macro that will filter the data from the main tab and copy only those records that contain "AGS".
Once the data has been copied, it can be pasted into the appropriate cells in the AGS tab.