Data Transfer-what terms I should be searching for?

[Screamer]

Hi,

I have numerous excel data files all set out in the same format with data in columns A, B and C from row 7 to row 8766.

I have all the calculations needed for the analysis set out in a seperate spreadsheet. I have never really used excel properly before and I am looking for an easy way to load the data from each of these spreadsheets to the calculation spreadsheet. Idealy I only want the calculations on one spreadsheet and to beable to load the data easily form which ever spreadsheet I need it from, and keep it "user friendly".

I have tried google to find methods but I don't know what terms I should be searching for.

Any help would be greatly appreciated in either how to do it or what I should be searching for on google to find instructions.

Cheers Screamer.

[VBA Noob]

Hi,

This link might help

http://www.rondebruin.nl/summary.htm

VBA Noob