open and filter using a hyperlink in html

[tav1035]

I have a webpage with links to an excel workbook where users open it, go to Sheet2 and filters on "A1" for their name to get their data.

I saw some samples of JScript doing everything but filtering, anyone have any code?

Can this be automated to autofilter on opening from hyperlink.

I could have multiple choices of hyperlinks-
Link to Tom
Link to John
Link to Sue

Thanks,tav