Produce an Excel workbook containing; all import sheets with links between sheets where common data is shared across the import sheets i.e. Employee Id

At the moment when compiling data for populating the import sheets there are a number of fields that appear across a number of different import sheets, for example {Employee Id}, {First Name}, {Last Name}. Where such repetition exists there could be links built in to the workbook so repeated occurrences of the same data are auto populated from the first sheet where the data is entered. This could be achieved using the built in functionality in Excel or by a visual basic module embedded in the workbook.