Pull information from different files with mult. sheets

Originally Posted by Miraun

Hi Ace;

Let me verify that I understand what you're asking:

You have X number of workbooks, each containing 13 sheets within. One of the 13 sheets contains the consolidated information from the 13 sheets.

Hi Miraun,

First of all thank you for you answer. Unfortunaltely it seems that I was not very specific in the explenation. I do have x ammounts of workbooks with the same structure each consisting of 13 sheets. They DO NOT have a "consolidation" sheet. So I need to pull out information like location from the first sheet from a specific cell, Name from the second sheet from a specific cell, Amount from the third sheet from a specific cell and so on. All these data should than be consolidated in on NEW workbook. I hope this clarifies what I meant.
Thank you in advance for your support !!!