Excel macro in Mac - populating a spreadsheet from other tab values : I am not familiar with VBA in excel macro, and I need to create a macro in excel for mac which does the following:

I have 2 tabs (wkst1 and wkst2) and need to populate a third one (wkst3)

wkst1 has one column with names listed
e.g.

A

B

wkst2 has two columns

X     1

Y     4

I need to populate wkst3 to ensure all rows in wkst2 are associated to each name listed in wkst1.

e.g. my wished result would be:

A     X     1

A     Y     4

B     X     1

B     Y     4

May you suggest the code I should use for this macro ?
Thanks in advance!