MACRO using VBA for contract tracking

Hello healthcarepropro and Welcome to Excel Forum.
For the information in the sample file it would seem that the following formula might work: =INDEX(Sheet1!$A$4:$D$10,ROWS(A$1:A1),MATCH(B$1,Sheet1!$A$3:$D$3,0))
Note that zero values have been hidden using conditional formatting: Cell Value = 0 (font set to white)
I feel that we are going to need a sample with more data on sheets 1 and 2 and with some (manually typed) output on the two sheetlogs in order to be of more help.
Let us know if you have any questions.