Hi Folks,
I have a rather complex requirement(for me). I have a Master sheet named "Master". In this there are names of employees. Now there are several other sheets named with Month & Year <January2014,Februrary2014...etc>.
In these sheets, lies the details of those employees.

My requirement is that If I filter in master sheet the names I want to see, automatically all the other sheets should also show only those employees' details which are selected in master sheet after filter.

Is this possible. (I know this is but don't know how.)

Please let me know of any workaround if this is an extremely complex requirement.