The workbook to copy the sheet into must be open.

With 100+ workbooks this will get a little tiresome.

One method would be to make a Template from a workbook containing only that
one formatted sheet.

Name this template SHEET.XLT

Store in your XLSTART folder.

Open each workbook and InsertWorksheet.

Or try your hand at VBA.

Ron de Bruin has code for adding a sheet to every workbook in a folder.

http://www.rondebruin.nl/copy4.htm

See Item #4


Gord Dibben MS Excel MVP

On Thu, 30 Apr 2009 12:20:38 -0700, boschuster50
wrote:

I have 100+ workbooks. each have to remain separate.
I created a sheet to add to each workbook with specific formatting.
I tried copy and paste, and lose the column and row formatting.
Also tried the edit; copy or move sheet, doesn't give me option of picking
the workbook I want to paste to. Please tell me I won't have to format each
sheet after pasting!