Transferring data from one worksheet to another
 

Hello

I am looking for a piece of code that will do the following using VBA:

1. Transfer data from one worksheet to another worksheet within the same
workbook (for eg. "worksheet for May" is copied to a new worksheet, which
will be renamed "worksheet for June". Some data on this new worksheet will
remain the same, while some will be modified)
2. On this new worksheet, the data to be modified comes from different
workbooks. (for eg. there are atleast 5 instances where data is copied and
pasted from 5 different workbooks)

Kindly let me know if its possible?

Thanks