Pick up values by parameters

[Matti Koski]

Hi,

How can I create following function which collects the information from
sheets 2-4 to sheet1? After I have activated Sheets 2,3 and 4, I will give
two parameters on Sheet1. A3 is the header and E3 is the value. It will pick
up the values on Sheet1 on line 2 (green, 6, 76, 2).

Sheet 1
A,B,C,D,E
A3,E3
Green,6,32,11

Sheet 2
A,B,C,D,E
Red,2,3,7,8
Yellow,4,5,9,6
Green,2,1,1,6
Blue,3,7,9,8


Sheet 3
A,B,C,D,E
Red,2,3,7,8
Yellow,4,5,9,7
Green,2,1,22,32
Blue,3,7,9,8


Sheet 4
A,B,C,D,E
Red,2,3,7,8
Yellow,4,5,9,6
Green,2,1,1,11
Blue,3,7,9,8

Thank you,

Matti

 

[Dave D-C]

It will pick up the values on Sheet1 on line 2 (green, 6, 76, 2).
Do you mean to say "(green, 6, 75, 2)"?