I'm still not clear on what you want. =SUM('Jan 2"!(D3) does not make sense. You probably only need ='Jan 2'!D3. My guess is you could use a Advanced Filter or a Pivot Table, but we need to know how your data is laid out! What are you column headers on each sheet? Where does the physician's name go?