Summary table updated from source table. Source table held in a different workbook

Dear all,

Please can you help me with the follwing Excel problem. I'm using Excel version 2010.

I have multiple source workbooks for example, apples, oranges, lemons etc. In one page in each of these workbooks there is a summary table of key data. Each source summary table is going to grow over time as new rows of information are added.

I'd like to create a new Summary workbook. In each worksheet in the new Summary workbook there would be a sheet for each fruit already set up. In for example the apple Summary worksheet I'd like this to be linked to the source apple file. So when a new row is added to the source apple file it will auto update in the summary apple tab. I'd hope the text and figures added (in green font in my example files) are updated in the relevant fruit worksheet in the Summary file.

I've enclosed three excel files that I hope will outline my question.

Any help would be most appreciated.Lemons.xlsxApples.xlsxSummary of fruits.xlsx

Thanks.

Many thanks newdoverman. I think I can make this work for my remaining files. Cheers.