I am beginnner in programming macros. I am having a tough time figuring
out how to accomplish the following:

I look through the archives and could find anything out on this. Any help
(website, links, or even partial code) would be apprieciated?

Here is what I have:

Sheet 1 - This is my controling sheet
Col A
Apples
Green Beans

Sheet 2 - This contains data
Col A B C
Apples 2 4
Banana 3 5
Carrot 6 6
Green Beans 1 4
Tomato 2 3


Sheet 3 - this contain data
Col A B C
Apples 1 3
Banana 3 7
Carrot 6 4
Green Beans 1 3
Tomato 2 2


Basically I want sheet 4 (which is blank to beginning with)
Col A
Apples Data from Sheet 2
Grean Beans Data from sheet 2
Apples Data from sheet 3
Green Beans Data from sheet 3