Pick up values by parameter
 

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,6

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