=IF($A$2=$B$2,'1st Shift'!$D$7,0)
A2=cell on yearly sheet
B2=cell on yearly sheet (for month of year =January)

On 1st shift sheet D7=month of year

I need to track data from the 1st shift sheet by month on the yearly sheet.
when I change the month in D7 1st shift sheet and replace with another month
I loose the data on the Yearly sheet