how can I combine multiple worksheets into a single workbook?

[don_15D]

I make daily spreadsheets with all the same columns and variable numbers of
rows; I want to combine all the worksheets from a month into a single
workbook file. Each of the previous files should be separate worksheets in
the new master workbook.

 

[Sheeloo]

Looks like you have one sheet per workbook and want to move all sheets to one
workbook. Are you looking for an automated solution or are you willing to do
it manually?

Manual method -
Open the destination workbook
Open the source workbooks one by one
Rightclick on the sheet to move and choose Move or copy
Select destination

Hope someone else will provide an automated solution or you can search the
forum...

 

[wcurtis]

I did not ask the correct question. I have a sort of template sheet I copy
into a workbook that has many sheets. Each sheet has a unique name and I
created a macro to count certain data in each sheet. The macro also inputs
two new columns, names the rows I want and places the counts into the proper
row. I need a way to transfer the data from say sheet AE1 cell B1 to sheet
Data cell B3.
Sheet AE1 cell B2 to Data cell B4, etc. I have about 22 worksheets in each
workbook to copy data from.
I appreciate the help.

 

[don_15D]

Though I didn't say so, I was looking for some automated method. I understand
about creating new worksheets in a destination workbook and then populating
it with the contents of the source worksheet. For example December, this
would be lots of repetitive tasks creating a consolidated workbook. Is there
an automated solution to do this?

 

[Ron de Bruin]

Try
http://www.rondebruin.nl/summary.htm

Or
http://www.rondebruin.nl/copy2.htm

 

[don_15D]

I looked over the link and the code, and it looks like it will work for me.

Many thanks!