Filter data from a Master sheet based on multiple criteria by VBA code

Hi All,

I need a vba code for this below problem, i have attached a sample file.

I have a master sheet with data, In the second sheet i have criteria selection, based on criteria, data should be filtered according to the field selected from the master sheet.

The format and the grand total should get adjusted based on the data filtered.
The S.No should be count based on the data filtered.

Any help much appriciated.

Many Thanks
Jude