workbook design advice

[e_var]

Designing a workbook to schedule staff to 2 different types of clinics, clinic parameters (date, time in, time out, number of staff required) update frequently. The clinic schedules are generated by a corp sales team, I can run a query and export into excel, it contains columns/data that aren't needed.
requirements:

1. ability for more than one person to update partial data. (shared workbook, use compare and merge)
2. highlight/track updated clinic info, and added clinics.

My design:

1. Create a Master shared workbook
   1. One WSheet for each month and clinic type = 24 (the two different clinic types are from different reports, no way to combine)
   2. Master schedule WSheet; pull only required scheduling information from all clinics and add additional columns to enter staff names, confirmations, etc
   3. Active schedule; the person assigning staff will enter dates in two cells and the code will display the clinics between those dates. (Q. How to update on this worksheet and have it copy back to the Master schedule WSheet. Q. Is the a way to sort and view only the clinics between the dates selected?)
2. Create two copies from the Master shared workbook and rename them, keep them in a folder on a shared work drive. Use the Cmopare and Merge feature
   1. Active Clinic schedule.xls ~ Hide all WSheets except the Active Schedule, include macro to save and close WBook at end of day to prevent staying open on personal computer and preventing merge of data.
   2. Clinic Schedule Update.xls ~ When the clinic reports are created from the corporate portal, I can copy the entire WSheet for the month for each type of clinic, and paste it in the Update WBook. When I use the compare and merge, it should update the Master and highlight/comment on what has changed

Making any sense? I'll upload a dummy WBook as soon as I can scrub the data.
Any suggestions/comments welcomed

 

[e_var]

Lets try another approach.....
This code is designed to search multiple worksheets and display the clinic ID number based on a dropdown box (cell B2) value the user selects...
If they select 'June' then

=IF(ISBLANK(INDIRECT(""&$B$2&"!$A"&ROW()-1)),IF(ISBLANK(INDIRECT(""&$B$2&"Flu"&"!$B3")),"",INDIRECT(""&$B$2&"Flu"&"!$B3")),INDIRECT(""&$B$2&"!$A"&ROW()-1))

The problem I have is when it searches the WSheet 'JuneFlu' it starts at the row where the first part of the search stopped (found blank cell). If there are 35 clinic in the 'June' WSheet, the second part of the search starts looking at row 35 on WSheet 'JuneFlu'.

How can I get it to start at the first row on each WSheet? I attempted to use SMALL but could not get it to work.