Generating an automatic report sheet which gathers selective data from a master file

Hello All,

I have been trying to figure out a way to generate an automatic report sheet in excel, which would gather selective data from a master excel file.

To make things more clearer:

1) I have an excel file with multiple sheets in different tabs. These individual sheets are basically specific Job Orders with details of the order. Every time a new order is placed, a new sheet is created in the same excel file with a unique Job Order #.

2) I am looking to create a fresh excel sheet which would have a summary of all individual Job Order #'s on a single sheet organized by columns. The purpose behind this is to have a snapshot view of all Job Order details as well as enable further analysis on that sheet.

3) The challenge: I want this new sheet to be able to pull data from the different individual Job Order # sheets automatically.

Is there a way to do this?

Regards,
Tanmay

Hi Naveed,

Thanks for getting back.

I have attached a sample of the Work Order File with this message. As you can see the file has multiple tabs of individual work order details. What I would like to do is create a new excel file, which derives specific information from these individual work order files automatically and present it in a summary sheet. The format of this summary sheet is also attached along with this message.

Since a new individual work order sheet will be created every time a new order is placed, will the summary sheet be able to automatically pull information from the master file for
the new entries?

Regards,
Tanmay

Hi Naveed,

I apologize for the confusion created.

The sample sheet was just an example intended for just a visual demonstration. You can
ignore the "DUE DATE" column on the sample sheet since that information is not there on theWork Order Excel File.

For the size column, currently there are 3 columns in the work order file, but I will make that into one common column in the future.

Warm Regards,
Tanmay

Yeah that is right

Hi Naveed,

I have a confusion regarding the Step 2.

How exactly am I supposed to " paste the full path of Summary worksheet in Work order workbook" ?

Regards,
Tanmay

Hi Naveed,

Here is the path for both the files on my computer:

C:\Users\Ravi\Desktop\Excel Help Forum

Regards,
Tanmay Chowdhary