I have a two part business problem I'm trying to solve and would greatly
appreciate some suggestions:

I have an excel worksheet I want to push out to the web for which I can send
someone to a link to access the site. I'd like the site to have a password
on it before the data can be viewed. Once on the site, they can make some
selections on the spreadsheet and send the data back to me. (Problem:
Password to access website, saving/sending results back to me)

2. When the web user logs into the website and then saves their changes, I
want to build a macro to run that will populate a summary of their selections
in .pdf format that they can print. Most likely this would be another tab on
the spreadsheet that would change based on the selections on "Sheet 1". This
second "Sheet 2"/"Summary" tab would then be printed to .pdf. (Problem:
Getting sheet 2 online and printing it to .pdf).

I know this is a pretty broad question, but if you could point me in the way
of a solution, that would be helpful. (To make it more complex, I actually
want to duplicate the above process about 200 times to a variety of users, so
suggestions that are scalable would be most helpful). Thanks,

Stephen