How to Copy a Cell from one worksheet and return
 

Can someone please help. I am tring to create a macro that will copy a field
from one worksheet (a list of property with over 2000 items) and return to
the worksheet I start on and paste the information. I have about 20
different worksheets (which all use the same list of items) and the marco I
tried to write always take me back to sheet(2). I use a seperate worksheet
for the items as the descriptions are in 5 columns, and I have set up filters
for the users.