Create Worksheets Based on Cell Values

[modytrane]

I am attaching a sample worksheet that shows what user input would look like. Based on the names and quantities defined by the user, would it be possible to create worksheets. These worksheets would be copies of preformatted and previously created master sheets. The master sheets could be stored within the workbook [Hidden] or in another workbook available on the network.

I had looked at this before with userform, but it doesn't need to be anything fancy.

Can someone help me with a Macro that could read the cell values for names and quantities and create copies of appropriate worksheets?

Thanks a lot for any help or suggestions.
modytrane.