I am using a Workbook which has a large amount of information, used by many people. 

I want to create a separate Workbook which pulls just 2 pieces of information from the larger shared Workbook, though the information is a bit scattered and is also separated into multiple Sheets within the Workbook.

To be more specific;

Is there a Formula that I can use to give me a list of all Work Order Numbers that exist within the separate Workbook ( Across multiple Sheets ) as well as the Work Order quantity which is recorded in the cell next to the Work Order Number ( Also across multiple Sheets ).

Thanks in advance for any help on this 🙂

​I am using a Workbook which has a large amount of information, used by many people. I want to create a separate Workbook which pulls just 2 pieces of information from the larger shared Workbook, though the information is a bit scattered and is also separated into multiple Sheets within the Workbook. To be more specific;Is there a Formula that I can use to give me a list of all Work Order Numbers that exist within the separate Workbook ( Across multiple Sheets ) as well as the Work Order quantity which is recorded in the cell next to the Work Order Number ( Also across multiple Sheets ). Thanks in advance for any help on this 🙂  Read More

​