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