Autofill not recognizing the intended pattern

I am trying to autofill a series of cells from another Sheet but cannot get the autofill to follow the intended pattern correctly.   The information in the first cell comes from ='Sheet1'!A1  I wa...