Wanted: Data Analysis Workbook
 

Hi All,

I am generating large amounts of data that need to be analyzed on the fly.
To simplify the problem, consider an Excel workbook that has n number
of data sheets, S1 to Sn. Each spreadsheet has 5 columns, C1 to C5
and x number of rows, R1 to Rx, in addition to the a header row. The
workbook also has one main sheet called Smain. The workbook should
be capable of doing the following automatically, either by pressing a button
or auto-refresh when the data is updated:

1. The rows of each data sheet should be sorted max to min according to C3.

2. If the maximum value in C3 of a given sheet is less than -1, the tab
color
of that sheet should be changed to red. If it is between -1 and -2 then the
tab color should be yellow. If it is between 1 and 2 it should be blue. If
it is
greater than 2 it should change to green.

3. The row with max C3 value in each sheet data sheet should be
automatically
copied into the main sheet, Smain. So, Smain will consist of n number of
rows
with each row being one which has the max C3 in its corresponding data
sheet.
All rows need to be sorted in Smain max to min according to C3. Same tab
color
condition applied to Smain.

Anyone can produce such workbook?