Good Afternoon - I know that this is a very basic function in excel, but I have a very extensive workbook that has approximately 20 tabs. The first 2 tabs are essentially linked to the last 18 tabs + items within the first 2 tabs as well.

I have information from FY 2010-FY 2014 ( So I have 5 rows), I want to delete FY 2010 and add FY 2015 to the worksheet, without adding/deleting an additional row, and I also want to keep the same links which flow through the workbook.

TIA,

RO