Creating new sheets from master list with VBA

If this has already been answered, feel free to refer me to the correct post---I could not find it through a search.

The following question will sound very similar to relational database design, where creating a new record in a parent table creates a detailed record in a child table. I am doing this in Excel because the end-users work almost exclusively in Excel and would like to integrate this with their other Excel data.

Assume I have a "Master List" sheet that contains summary information. Column A in this "Master List" contains a unique numerical value for each line. I would like a new worksheet created from a template each time I add another line, with the value in Column A hyper linked to the new tab.

For example, if I enter a value into A7, I would like Excel (VBA) to create a new worksheet (from a predefined template) in the same workbook, with the worksheet tab named after the value in A7 and the value in A7 hyperlinked to the new sheet.

Any ideas???

Many thanks in advance,
Joel

royUK---

I agree, however, each "record" (row) also has a 10column x 40row checkbox table associated with it. I cannot think of another way to attach a 10 x 40 table to a single row in Excel other than to keep all summary data in the master list, and hyperlink to the 10x40 table in a separate worksheet.

To add insult to injury, they want each record to print one to a page.

Whadya think? Should I just tell them to learn to use a database?