Getting data from multiple workbooks to different sheets of a workbook

Hello
I have multiple excel workbooks in a folder ,I can pull data from them in a new work book.but how can I pull data to different sheets.
say I have work books....A,B,C in a floder and I want work book "A" data to be pulled in "sheet1" of new work book and "B" to "sheet2",C to sheet3.

thanks

I am not an VBA expert and can help you enough with that.

But why not all data in 1 worksheet. That makes it (to my opinion) a lot easier to analyse the data.

This one is to get all data from differant worksheets in 1 workbook.

I made this on your example in your other threat.

The value of the timestamp needs to be changed (see blue cells).

After that a pivot table.

Or do you mean multiple workbooks in a directory. In that case you will need differant code, but that does not match your link to the other question.

See the attached file.

Please Login or Register  to view this content.

Please don't PM me for this request.

If you post it on the forum, you have the reach of all forummembers.

I changed the 2th url, because I don't know if it contains confidential information.

If it does not contain confidential information, feel free to post it again.

help with filter,subtotal and getting nonadjacent cell data

regarding my post here
https://www.excelforum.com/excel-gen...ml#post5337525

as my file size is 7 mb I have uploaded on mediafire

http://www.mediafire.com/file/etc.

Please also add your location in your Profile.

@PandaWarrior

If you are satisfied with the solution, please mark the question solved.

You can add reputation by clicking on the star * add reputation.

thanks oledere I solved it solved