multiple sheet reference

Thanks for that spreadsheet. That's what I had. I used 2a2 to mean sheet2 cell a2. Probably should have made that clear. Apologies if that's not correct way to refer to cell.
I have another one if you could help...
Say sheet1 has A1:A15(apples, oranges or bananas), B1:B15 (date of order), C1:C15 (quantity), D1:15, (country) E1:E15 (buyer)
On sheet2, sheet3, sheet4- cell H1 says apples, oranges and bananas, respectively.
There are only columns for date of order (A), Quantity (B) and Buyer (C)
Is it possible for sheets 2, 3, 4 to fill the required values automatically from data entered on sheet1?

Jason,

I would appreciate if you could attach an example spreadsheet to understand the scenario better....

Okay Adil. Thanks.
Example.xlsx