Automate filtering of multiple lists and transposing results onto another worksheet

Hi,

I need some advice on how i can filter multiple columns on one sheet and for different variables then transpose the results onto another worksheet.

I've attached a demo of what i want to do!

Basically, filter columns C-I for each of the variables i.e. sd,y and x

Then those that match the criteria for example 'sd' copy the name and paste it onto sheet 2 under the corisponding day.

I would like this to update automatically, if possible, as i know this can be done by macro by filtering each column independantly for each criteria and copying the names across. However, i forseen that the data will be changed frequently and therefore running the macro each time to update sheet 2 will be very time consuming.

Please offer suggestions for this problem, also note that i'm not that good with VB.

Thanks in advance