I have multiple worksheets in one file that track various aspects of our employees information. One shows their generic human resources type of info, one shows their payroll information, one tracks their time off, one tracks their benefit information. When I add an employee I must go into all four spreadsheets and insert the row and put in all their info, much of which is duplicated from worksheet to worksheet (name, soc sec #, date of birth, date of hire, etc.). Is their a way to link the spreadsheets so that anytime I insert a row into the human resources spreadsheet (since that sheet is alphabetical, I insert rows), the other three worksheets will automatically insert a row as well and copy in the basic information?
Thanks in advance for any insights.