Updating Master Sheet from other Workbooks

[mikepj]

I'm having a difficult time trying to get my head around this, and i'm not even sure its possible. But what I'm looking to do is to find a way automatically update a master excel file with data from seperate worksheet files, which are then cleared of data.

For example my master spreadsheet has a number worksheets labelled with place names, London, Cardiff, Swansea, etc which correspond to separate spreadsheets which might come in on a regular basis. I want excel to look into the separate worksheets and when it finds data, cut the data and paste it into the next available row in the corresponding worksheet of the master file.

Hope some one can put me on the right path. I've been googling for days, and come across linking individual cells, consolidation, merging, but haven't come across anything that gives me any clue to what I need to do.

[VBA Noob]

See if link helps

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

VBA Noob

[mikepj]

Thanks for the link, its appreciated. However I'm not really looking to summarize spreadsheets, so much as to compile a master workbook with multiple worksheets, whereby a macro will search for data within a given range inside a feeder worksheet, and if found transfer it across to the master and then clear the feeder worksheet.

Another link on the site 'Copy a range from closed workbooks' seems half way there. However I'm looking at these macros and its kind of making my head spin.I will give it a rest for tonight and get back to it tomorrow. Fingers crossed.