We have an Inventory Issued spreadsheet with the main tab listing all of our supplies, prices for each supplies and beginning inventory, number of items purchase and number issued. We then have tabs set up for each one of our departments also set up and they are identical to the main inventory tab. When we use a new supply we have to insert a row into the main inventory tab and enter all the information, we then go into the 15 different department tabs and insert a row at the same spot and enter all the information. We do this for each tab. Is there a way, when we insert a row and information in the main tab, all the department tabs will automatically insert a row with the same information?