I have a workbook with multiple sheets in it, and then a copy of the multiple
sheets, ie: a1, a2, a3, a4, and b1, b2, b3, b4. b1 is identical to a1 but in
a different language (all columns/rows match exactly). I would like to write
a macro that allows me to select particular cells from a1, then pastes and
links them into their equivalent in b2. Basically, just a shorter way then
selecting a A:1 on a1 copying it, switching to b1, clicking on A:1 and
pasting special link.

Any help would be appreciated, thanks,

Lance