Excel: Create master list from worksheets

Question

I have a need to create a master list in excel from various lists on other worksheets. The sizes, colors, other attributes will change so this will need to be done on occasion. The example data is:

Worksheet 1 "Products" contains: Product Name Product A Product B Product C Product D

Worksheet 2 "Colors" contains: Product Color Red Blue Orange Yellow Green

Worksheet 3 "Sizes" contains: Product Size X-Small Small Medium Large X-Large

I need the completed list to look like:

• Product A Red X-Small

• Product A Red Small

• Product A Red Medium

• Product A Red Large

• Product A Red X-Large

• Product A Blue X-Small

• Product A Blue Small

• Product A Blue Medium

• Product A Blue Large

• Product A Blue X-Large

• Product A Orange X-Small

• Product A Orange Small

• Product A Orange Medium

• Product A Orange Large

• Product A Orange X-Large

• Product A Yellow X-Small

• Product A Yellow Small

• Product A Yellow Medium

• Product A Yellow Large

• Product A Yellow X-Large

• Product A Green X-Small

• Product A Green Small

• Product A Green Medium

• Product A Green Large

• Product A Green X-Large

• Product B Red X-Small

• Product B Red Small

• Product B Red Medium

• Product B Red Large

• ...

• Product D Green Medium

• Product D Green Large

• Product D Green X-Large

Is this possible? Thank you very much in advance!

Answer 1

You can find two approaches from me at Combine Multiple Tables Rows Into Master Table

One of those uses VBA, the other uses PowerQuery (Excel 2010, 2013) aka "Get & Transform" (Excel 2016).