I have developed pages that randomly define a set of normal lung
function data based on gender, age and height. I have applied formulas
to this data simulate 5 classic lung function abnormalities (normal,
restrictive, obstructive, mixed and early obstructive.) Currently
the sheets that define the abnormal are named by one of the above lung
abnormalities. I would like to present data from random pages in a
work book to students and rather than have the pages named by the
abnormality be named a simulated patient name.

My questions.

Can I have the name of a sheet set to equal data from to cells (e.g. a
male first name and another last name?

Can you randomly present sheets?

Should I use a pivot table to do this?