"do this" means what?
You say you have several worksheets with text -same size col. & rows
What more do you want?
If you had only one worksheet you could copy it several times.
Right-click on sheet tab and "move or copy"
Check option at "create a copy"
Gord Dibben MS Excel MVP
