How to Copy Data from multiple workbooks to single workbook

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...

Yes.. All the sheets have similar data.. The sheet name is also same in all workbooks..

Can u explain it a bit?? I couldnt understand the code in order to modify it for my specifications..

I understood after going through help files..But i m still unable to modify it as i mentioned in earlier post that "data in the slave sheet doesn't start from the cell(1,1), it starts form (10,1) instead.

and there is one more requirement, i want the slave sheet name in the master sheet sand then followed by the data... i.e.slave sheet name in column 1 and followed by data from column 2.."

I mean to say is that the data to be copied starts from (10,1) earlier rows contain data, but that is nt to be copied..

Snb,

Could you modify your code so instead of copying the data to a single worksheet is copied into separate worksheets?

Please Login or Register  to view this content.

Thanks in advance

Lupis, I just recently finished a similar project to yours. What I did was I imported the data to a single worksheet in one step, along with a note for what worksheet I wanted the information to end up in. Then in the second step, I copied the data into the proper destination sheets. Since this is all, of course, in VBA, the end user doesn't notice that it's being done in two separate phases.

I'm also going to give you a piece of code that takes a cell reference, sheet name, file name, and file path, and it returns the value WITHOUT opening. Because while assuming that you're going to have something open is nice, I like this a lot better.

Please Login or Register  to view this content.

thanks Freakietiki34.
The thing is that I am pulling files from SharePoint, opening each of them but not saving them because I don't need to save them. I just need to copy the data from "Sheet1" for each file and put the data on separate worksheets on another workbook.

I have submitted a new post.
thanks