Consolidating Data

[The Grim Discovery]

Hello people

I'm stuck. I'm trying to consolidate data from three workbooks called 'Oct', 'Nov' and 'Dec' into a new master worksheet. Not found anything on here pitched to my very basic level of understanding and nothing on the office support forum that I can make work.

There are several bits of consolidation I want to carry out but I'm guessing if someone can help me with the first I can work out the rest for myself.

'Oct', 'Nov' and 'Dec' are identical in design and format and I want to consolidate the data each holds in their respective cells A2:A50 on 'Worksheet 4' (each of those workbooks contains a sheet called 'Worksheet 4'). This data is not set up as a named range - not sure if that's a problem. I'm failing miserably when I try to point the consolidation function (Excel 2010) towards these specific cells. Any help or alternative ways (preferably as simple as possible) would be appreciated.

Thanks

 

[orjanmen]

Have you tried this? It works for me: http://www.excel-easy.com/examples/external-references.html

 

[The Grim Discovery]

Result, cheers.