Assigning macro to object

Hi Doug,
Thanks ever so much for getting back.
My first worksheet has 2 buttons. I have created a macro for these. The first button has text in it which says 'Residential' and the second has text which says 'Commercial'.

In terms of the code the buttons which reads 'Residential' says:

Sub Residential ()
Worksheets ("Question 2").Activate
End Sub

The button which reads 'Commercial' says

Sub Commercial ()
Worksheets ("Question 2").Activate
End Sub

On the second worksheet, I have a further question.
This says, which company do you currently use for your searches?
- 'ABC' (I am changing name here)
- 'BCD'

I have created 4 worksheets after these 2 questions which I want to take the user to, depending on which button they click on the second screen. I want Excel to store as a variable the response to Question 1, and the response to Question 2, to take the user to a unique worksheet. i.e. if user answers Residential to the first question, and BCD to the second, then they should be taken to a page set up for BCD residential.

The four variables I need to record as strings would be
1) ABC Resi
2) ABC Commercial
3) BCD Resi
4) BCD Commercial.

I hope that this clarifies things.
If you have any more reuqestions, please let me know.
Thanks
Jonny