Hi

I have a number of workbooks, which in turn has 12 worksheets each named as 12 months i.e. Jan, Feb, Mar, Apr etc.. Now i want to copy the data in these workbooks to a single master workbook, which has similar 12 worksheets. i.e. master workbook's Jan sheet should contain data of the slave workbooks' Jan sheet's data. Also it may be a possibility that the particular slave workbook does not have data in Jan, mar, apr, sep sheets, but have in all other sheets. The data format and pattern is exactly same in all workbooks and the master workbook.

I hope i am able to explain the problem well... Plzzz help!!!
Thanks in advance...