Attached is a simple sample workbook using sheet data un a URL. (It just goes to Google and searches for the department you clicked on.)
I show it two ways. The first builds the hyperlink in a calc field, and then just uses the calc field in place of the URL in the action.
The second inserts the department field into the URL in the action.
The problem I see is that you don't want to pass just one value to the URL. You want to splice in 100 values if that's what the user selects. If that's true, ummm ... we'll have to work on something. I'm not sure if you can do it that way. But before I put time into that, let's be sure that's what you really want to do.
hyperlink example.twbx 970.1 KB