With Workbooks("Master.xls")
Workbooks("Newbook.xls").Worksheets("Sheet1").Move _
befo=.Worksheets(.Worksheets.Count)
End With

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Rambler" wrote in message
ups.com...
Hello

Realtive newbie here!

I am looking for a macro that will move worksheets to a master
workbook.

I have an order form with macros that save a file as a certain name and
forward it via email that works fine.

I want to have a macro the inserts the order worksheet into another
workbook so copies are kept in one master file. Another option is a
macro to post values to another workbook posted on a network drive,
where they can be totaled, i.e. order one becomes line one in another
workbook

Any suggestions?