Copy temp hidden sheets

Originally Posted by YasserKhalil

Thanks Mr. Stan
As clue for solution ..
We can loop through range("Q2:Q8") and for every loop copy the two temp sheets and rename them based on cell value (Q2 in first loop) adding the suffix A for first temp sheet (COM 1A in first loop) and adding the suffix B for the second temp sheet(COM 1B in first loop) ..
Then Copy range(A2:C22") to COM 1A >> (the rows would be based on range(R2:S2") for first loop)
repeat the last step but copy range("I2:K22") to COM 2B >> (the rows would be based on range(R2:S2") for first loop)

YasserKhalil,

I do not understand why the two worksheets are hidden.

And, I do not understand what you are trying to do.

One last try:

Please manually complete worksheet Sheet1 with its results from the two hidden worksheets, TempA, and, TempB.

Then repost the workbook, worksheets, again.