Hi enwoznick,

Don't do the problem using different worksheets for each medication. Keep all medications in a single table and then filter it (as needed) to show what you need to see. This is a much better method as Excel has great tools dealing with a single table.