Anyone here know whether you can switch repeating rows in Excel on the fly, with VBA? The idea is, the sheet contains multiple grids, each with its own set of header rows. But the headers may be different, one grid to another.

Anyone here know whether you can switch repeating rows in Excel on the fly, with VBA? The idea is, the sheet contains multiple grids, each with its own set of header rows. But the headers may be different, one grid to another. 

My suspicion is that separate sheets is the only real solution.