I am trying to a create a workbook in which information regarding a client's medication regimen would be entered into separate sheets for each medication. Each medication would include the med name, dosage, directions and prescriber info with some other info formatted into the sheet. I want to create a summary sheet for the entire regimen which would lay out each med, dosage, direction and prescriber info into columns and allow users of the workbook to delete and add sheets for medications as they are changed.

Right now I have done this by labeling cells using this formula on the summary page but the problem is this will not be sustainable as meds are added or discontinued (ie sheets deleted or added):

= IF(med9name= ISBLANK(TRUE), " ",med9name)

Is this possible?