Cathy,

By far the best way of doing this I feel would be for the first
question to supply a drop down box (Data- Validation)with the options
for departments.

Say in cell A2 (select this cell)
To do this go to Data Validation
In allow select "List" In the source section type in your list of
departments seperated by commas eg
Drilling, Subsea, Operations
etc

Then link question 2 to the selection from that box as you request with
a concatenation

In the cell that contains Q2 you should enter

="Question 2: Please comment on "&A2&" procedures as they pertain to
you?"

This will automatically update with different selections in A2


Play around with this...
I have found it very powerful for forms and templates,
as you can mak such things foolproof to the user,
plus there are countless extra settings

I found the website contextures.com very useful.

If you need anymore help feel free to ask

somethinglikeant