Excel Formula To Copy Value From One Worksheet Into Cell On Another Sheet

I'm hoping this can be done. I'm working and editing some old data to be imported into an Access database. What I would like to do is this:   Sheet 1 has two columns: 1A, 1B Sheet 2 has two column...