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

="Please comment on " &
if($B$2<>"",A2,if($B$3<>"",A3,if($B$4<>"",A4,"Unknown"))) & "'s procedures
as they pertain to you?"

or in a cell offscreen (perhaps W1, put in the formula)
=if($B$2<>"",A2,if($B$3<>"",A3,if($B$4<>"",A4,"Unknown")))

then in your questions
="Please comment on "&W1&"'s procedures as they pertain to you?"