I want to setup a master data spread sheet that will update automatically
from data entered in muliple other sheets.

Bassically if I enter data additional data into the existing sheets that
data would automatically appear in the Master data sheet.

Does Anyone have any answers?