All permutations and combinations

I have 3 set of values

Set 1 contains (A, B, C, D, E)

Set 2 contians (1, 2, 3, 4)

Set 3 contains (W, X, Y, Z)

I want to create all possible combinations by taking 1 element each from each set, is there any way Excel can create these combinations automatically e.g.

A, 1, W
A, 1, X
A, 1, Y....and so on

By all combinations do you also mean that values such as "3XA" or "ZC3" would also have to be generated or is it just the A value going down through the other groups to make all combinations in Top / Down way?