Autofill.........

I am dragging informaton on one tab from left to right in an effort to retrieve information from the 2nd tab that's listed vertically. Unfortunately, the cell just repeat themselves instead of retrieving the info from the 2nd tab.