Applying a Macro to several future worksheets

[bent_dietrich]

Hello Excel experts,
I am currently working on a macro that imports data from several workbooks, and then places the data in its according sheet in the new workbook, and rearranges it into a new format with several additional calculations. The macro is currently working well, but there is one part of it I have yet to complete. Since it's a sales forcast, I need the macro the be capable of automatically creating a new document when a new sales forecast is released every month. As an example to make it more clear, say I have data in "Document1" that has data that needs to be imported into "CombinedDocuments1." Next month I receive Document2 and require it to be placed into "CombinedDocuments2." Any help would really be appreciated, thanks.