would like code for each cell in order to pull necessary data from the tables on the right and make the necessary calculations to achieve the results show as follows:

The sales person shown in B7 means that data for this area will be taken from the table labeled "weaver" to the right. The data corresponds as follows:

B6 is simply the DATA found in Z14

C5 is the sum of all data from X4:X13 found in column "W" hence the result 5

D5 is them sum of all data from Y4:Y13 column "L"

E5 is the minimum number found in Z4:Z13 column 'ERA'

F5 is the maximum number found in AD4:AD13 COLUMN 'ER'

G5 is the average of all number found in AD4:AD13 column 'ER'

H5 is the minimum number found in AF4:AF13 column 'SO'

I5 is the maximum number found in AF4:AF13 COLUMN 'SO'

C7 is the sum of all data from X9:X13 found in column "W" hence the result 5

D7 is them sum of all data from Y9:Y13 column "L"

E7 is the average of data found in Z9:Z13 column 'ERA'

F7 is the minimum number found in AD9:AD13 COLUMN 'ER'

G7 is the maximum l number found in AD9:AD13 column 'ER'

H7 is the minimum number found in AF9:AF13 column 'SO'

I7 is the maximum number found in AF9:AF13 COLUMN 'SO'

The same will be done for the side of "Salazar" only this time the data will taken from table with his name (i.e. Salazar). and put into the correspoding cells within the table.

DataCalculations.xlsx