Okay I will try again.

I have about 8 sheets.
Sheet one is Method 1
Sheet two is Method 2
Sheet 3 is Method 4
then some misc sheets
sheet 8 is totals which intergrades all the sheets together. with some more
information on it.

Method 1 is a family members wages
a family can have up to 4 workers.
Dad for example may get a second job so we just want to copy the sheet and
have it called Method 1 (2). Which is the default.
After the new sheet is filled out the total for that sheet is located in
cell H38. I would like that amount to be availabel in the totals sheet.

I hope this helps.

Again thak you for your help.

"Rick Rothstein (MVP - VB)" wrote:

Your initial post asked "If a person were to add a tab will call Method 1
(2) can it instert a row into the totals page?", so I gave you code that
inserted a row. Anyway, you are saying that instead of inserting a row, you
now want it to copied... what is it that you want copied? And where... are
we still talking about the Totals sheet? If you are still talking about
inserting a sheet, I don't see what there is to be copied into the Totals
sheet... there is nothing on a newly inserted sheet. You are going to have
to provide more details (and while you are writing your requirements up,
remember that no one here knows what your set up looks like, what your data
looks like, how you plan to use your data, etc.... so you have to tell us
this instead of assuming we can guess it).

Rick


"Chey" wrote in message
...
You are right I was vauge. I did what you said and it workes just like
you
said it would. However instead of insert can it be copy? Also on the
newly
copied sheet I would like cell H38 to show on totals in cell B4. How the
sheet names transfers over is great. I like that.

Thanks so much

"Rick Rothstein (MVP - VB)" wrote:

Your question is lacking in a lot of detail, but here is a general
approach
you should be able to build on. Press Alt+F11 to get into the VBA editor.
In
the Project window (it has a listing of all your sheet names)... double
click on the ThisWorkbook item. Doing this will open up a code window for
the Workbook... copy/paste the following into that code window...

Private Sub Workbook_NewSheet(ByVal Sh As Object)
Worksheets("Totals").Rows(4).Insert
Worksheets("Totals").Cells(4, 1).Value = Sh.Name
End Sub

Now, go back to the spreadsheet and insert a new sheet, then look at Row
4
of your Totals sheet.

Rick



"Chey" wrote in message
...
I don't know if this is possiable but if so it would be great. I have
tabs
will call them
Method 1
Method 2
Method 3
Method 4
Totals
If a person were to add a tab will call Method 1 (2) can it instert a
row
into the totals page?

I tired creating a row with the path to Method 1 (2) thinking if I were
to
add it, it would carry the information over.

I am already working with macros, so if there is a macro to do this
that
would also work.

Thanks a bunch
Cheyenne