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.