Moving worksheets from workbooks in one folder to workbooks in other folders of same name.

Hi,

I am new to Macros and I am having a lot of trouble with this. I have a folder with about 90 timesheets. Each timesheet has 12 worksheets in them. It goes by the month. April, May, June, All the way to the May again. So what happens is at the end of every month Managers approve these time sheets and then the next month they are submitted back again and so on. The problem is the approved time sheets are not returned to the submitting party due to which when they submit the next month time sheet, it doesn't reflect managers approvals on it from the previous month. However, in a centralized location we need to keep all approved 90 workbooks and each workbook must reflect the approved worksheets in it.


Having said that, what I am really trying to do is

A folder contains Workbook XYZ and it has April worksheet that is approved and I want to import/copy that particular worksheet in another workbook of same name ( XYZ) in a different folder and repeat that for the other 90 workbooks as well.

So for now, I have one folder with all January worksheets approved and one folder having all February worksheets approved and I am trying to have a workbook which will have both of these approved work sheets. They both are in different folders but the workbooks have same names and all worksheets.

Please kindly help me with a VBA for this. If you are using a similar macro or can help me with one for this cause I would deeply appreciate it.

Thanks in advance!

Can you please see this.png

Can you please see the attached image. I tried to do it for January. Please let me know what I am doing wrong.

Thanks,
Mohammad

Sorry, I am still getting an error. I selected MS Scripting Run time.

Can you please see this.png



Can you please see this 1.png

Can you please let me know what I am doing wrong. Once again, thanks for all your effort.

Thanks,

Sorry, I forgot to mention that Apr-2015 is the name of the worksheet.

So in each workbook, that is how worksheets are labeled.

starts from Apr-2015, May-2015,............................all the way to the last worksheet which is named as March-2016

One folder is named as "C:\Users\fareedmo\Desktop\Master Timesheets: ( This is where I have 90 sheets and I am trying to get Apr-2015: which is the April sheet and I want it to come from "C:\Users\fareedmo\Desktop\January" ....


Sorry, I thought I would give you more information and may help you understand better because I feel a little confused after your explanation.

Thanks for baring with me..

Does this mean, If I want to use this code all worksheets names have to be changed to just the month names?