merging workbooks

[april]

i sent this message yesterday but since i don't see its posting i assume that
it didn't make it from my Outlook to this web site. please bear with me if
this is a repeat.
i have a workbook, Master, with 162 tabs - one for each project. each one
of these worksheets has a budget template on it. i want to send the
worksheets to field offices, have the field fill in the budget and then send
the worksheet back to me. Instead of copying and emailing parts of the
Master to the appropriate offices, i think that it would be better to just
send a template, have the offices fill in the data and then send the
worksheet back to me. how do i then populate a Master from these worksheets
so that it has a tab for each project?

thanks in advance for your help.

i think that this problem is similar to another question on merge that was
submitted yesterday

 

[Ron de Bruin]

I reply with this yesterday:

Send the one sheet template workbook and merge the one sheet workbooks to one when you get them back.

Start here
http://www.rondebruin.nl/mail/folder2/saveatt.htm

Then use the code here
http://www.rondebruin.nl/fso.htm

 

[april]

thank you. i'll try this when i get home tonight.