Alternative for Pivot table - row data

Hi,

Can anyone help me with the following. I've prepared a file with a data (download) where I've a pivot table linked to. Now I would like to replace the pivot table by a VBA script so the user need to fill in one field (cell L1), which is the parameter and the result should appear on the screen (cell K4 untill last row possible). On the attached excel file I would like to replace the pivot table on column F and G.
Anyone can support me with this. I've been looking for an answer for a long time on internet but unsuccesfull. I know for some of you this would be simple query but I reaaly appreciate if someone can help me with this.

See attachment for a UDF based approach.

Thanks a lot for your help. I really appreciate. This is indeed a different way to retrieve the data without using the Pivot Table. I also raised this question on a different forum (didn't know where to start the query as I'm a new member of this Forum) and there also received a different approach. IŽll investigate both and use them definately.

Thanks again