Auto-populate certain rows in excel

Not sure if excel has the power to do what I'm asking but I would like to create a worksheet and then from that worksheet choose specific rows to populate another work sheet simply by clicking on the row I want.

So for example i have information on rows 2-30 on worksheet A, but on worksheet B I only want rows 2,3,15 and 30.

Is there a way I can use 1 cell in worksheet A to populate worksheet B?

I know this is asking a lot from excel but if I can get it to work it would save me a lot of time and more importantly cut down a lot on the risk of making a mistake.

Any help is appreciated!

- - , .