I have a workbook that fires macros when opened so users only have access
to a form to add and amend data - this workbook holds data I need in the
workbook mentioned below.

When the second workbook opens, it shoud retrieve all data in Sheet1 in the
first workbook (or simply delete current Sheet1 and replace with a copy).
Does anyone have a simple method?
--
Steve