Hi!

I have worked with Excel for a while, but I'm NOT an advanced user!
I am working on creating a tool for creating contracts, and I want to make a "front end tool" which uses an external workbook as the source document. The source document is not open when working in the "front end document".

The source document is an address list which consists of several columns. In my "front end workbook", I want to echo the source list. I also want the front end document to update itself according to the source list every time I open the front end document.
As I will do some maintenance on the source list from time to time, I want my front end document to be set up so that it updates the whole address list, even if I have added rows afterwards. The reason for this is that the front end document has to be easy to use, because it's going to be used by several users, not necessarily experienced with Excel formulas.

So:
How do I echo the address list into my "front end" workbook?
How do I automaticcaly update?
How do I make sure that the echo range automatically extends as the source list grows?

I hope I have been able to express my needs even if English is not my mother tongue. All help is deeply appreciated!

Best regards from Norway.