Help! How to do Cell reference, address, index, indirect of different sheet

[snagy23]

Dear all, appreciate anyone who can give me a head up to solving this problem.

SheetA

_____A_________ B___________C______D___
1|Unit no._| company name |__rent __| year |
2|01-01___|__________ABC|__$1,000| 2010 |
3|________|_____________|__$2,000| 2011 |
4|________|_____________|__$3,000| 2012 |

SheetB

_____A_________ B___________C______D___
1|Unit no. | company name |__Year 1__|__Year 2__|__Year 3__|
2|__01-01 | _________ABC|___$1,000_|__ $2,000_|___ $3,000 |

I have a set of data that is presented in sheet A.
It is needed to extract and present in sheet B of such format.

1) there's a need to click manually for sheetB!A2 "=SheetA!A2"
(there are some data which is not needed therefore, manual selection is used in sheetB)

Question:

the reference in sheetB cell will be as follows using manual clicking method;
SheetB!B2"=SheetA!B2"
SheetB!C2"=SheetA!C2"
SheetB!D2"=SheetA!C3"
SheetB!E2"=SheetA!C4"

i can see that there are some patterns in adding of the row or column number, how will i be able to extract "sheetA!B2" address to be manupilate with adding or subtracting row or column numbers?
my guess that something of the things like address, index or indirect may be involve?

Many thanks for any advice given!

Roy

PS(im not allow to duplicate the data within the sheet, example unit no. or company name therefore, lookup may not be the best option).

 

[snagy23]

Any help will be greatly appreciated.

many thanks!

 

[RSXchin]

it'd be a LOT easier if you could have 01-01 all the down until the next unit number...