Extract some rows in Excel

all the sheets that are ending with G i.e Drive G,CMC1 G, CMC2 G,PKMF G,RMF G