Combining data from 2 sheets into one with multiple rows per data from 1 sheet

Hi all, I think this should be fairly simple but can't figure out how to do it and i'm feeling really dumb...
in sheet A i have a list of user IDs.
in sheet B i have a list of dpts and form names

I want to create sheet C that shows a row for each user ID and dpt/form combo from the second sheet....

So would look like this:
sheet1
user1
user2
user3

sheet2
dpt1 form1
dpt1 form2
dpt2 form3
dpt2 form4

Final sheet i'm trying to create from above:
user1 dpt1 form1
user1 dpt1 form2
user1 dpt2 form3
user1 dpt2 form4
user2 dpt1 form1
user2 dpt1 form2
user2 dpt2 form3
user2 dpt2 form4
user3 dpt1 form1
user3 dpt1 form2
user3 dpt2 form3
user3 dpt2 form4

that's all! any help would be much appreciated!

Thanks Paul! your assumptions were correct and this worked... took me a bit to figure out where to put this code, how to run it, what to tweak etc. but worked like a charm! Thanks so much, saved me a bunch of manual effort! Man I need to learn how to be able to whip up code like this... such a time saver! Thanks again!

No worries, it helped me learn it and understand what it was doing! Thanks!