need to take each value from a list and copy it into a template and output a new worksheet

[weakmacros]

Hi everyone,

Can someone help me with a macro?

I need to take a list of projects and combine this with a template listing out descriptions. Each project needs to have the same descriptions and I need to output a new worksheet after.

Here's an example:

Project (Columns A & B):
A B
Chemistry Atoms
Physics Neutrons

Template (3 columns)
A B C
Revenues Plan Approved
Revenues Forecast Working
Revenues Actuals Approved

Desired Output in a new worksheet:
Chemistry Atoms Revenues plan Approved
Chemistry Atoms Revenues Forecast Working
Chemistry Atoms Revenues Actuals Approved
Physics Neutrons Revenues plan Approved
Physics Neutrons Revenues Forecast Working
Physics Neutrons Revenues Actuals Approved

Any help would be appreciated!

Thanks!