You can break down your task into several stages as follows :
1. Create three arrays, one to hold the list of numbers , a second to hold the list of alphabetical letters, a third array to store the list of colours and a fourth array to store the list of countries.
2. Get the values from sheet 1 and place/ save them to their respective arrays.
3. Step through the arrays using nested loops to generate all possible combinations.
The code will look something like this:
for i=0 to UBound (ArrayLetters)
for j=0 to UBound (ArrayColours)Next
for k=1 to UBound (ArrayCountries)
for L= 1 to UBound(ArrayNumbers)
'create combination and save to an array of combinations
ArrayCombinations(m) = ArrayLetters(i) & " " & ArrayColours(j) & " " & ArrayCountries(k) & " " & ArrayNumbers(L)
'increment m by one to hold array index for next combination
I hope this sets you back on track to solving your problem.