I am using Excel 2003. I was really hoping to avoid the use of ranges as the data in the source document will always be increasing. I have looked at 2 other solutions to my problem:

using INDIRECT
This is not quite what I'm after as it requires the source document to be open at the same time. It also seems to be a little slow at updating the amount of data I have.

Just using =
This links to every cell in the source. The problem with this is that changes to the source document (more rows of data, insertion/deletion of rows) can play havoc in the destination. It also shows blank cells as '0' - this can be defeated by use of IF and ISBLANK, but things are starting to look messy.

Essentially I want to import an exact replica of a worksheet into another workbook (which stays up to date)- why is this so hard? I've noticed numerous other people on this forum with a similar desire. C'mon microsoft - google will have you for breakfast if you can't sort out basic things like this!

Any other suggestions, good people?

j