Formula or VBA to insert user defined Variable into Data Validation List

[Matt F]

I am working on a test report template.

This will include a predefined list of Test Requirements in a data table.
The user will be able to add as many rows to this data table as they would like.

I have also developed a predefined list of possible issues mapped to these test requirements.

I would like to find a way to inject a user defined variable into this list of issues.

I have created a workbook to help illustrate this problem.

All predefined data will be stored on a hidden worksheet called "Data".
Each worksheet will be named after the Page Name in (Cell B1).
I am pulling the Test ID via Data Validation, and the Issue list from an INDIRECT reference in a hidden Column (C).

This test report could have many individual pages (worksheets) referencing the same test requirements and Issues.

Is it possible to resolve this with a formula? If not can we create a macro to inject the variable into the issue list.

One final request. I would also like the user to have the ability to create their own issue description as well, but since the Data Validation list is referenced via INDIRECT I don't think that is possible.

Any help would be greatly appreciated.

Thanks in advance.