I have two workbooks "Tangible Capital Assets" and in the workbook are
worksheets with the various years, for example 2008-09. I also have another
workbook called "2008-09 Capital Submission" in that workbook I have a
worksheet called "Cap 11-Tangible Capital Assets".

I want to be able to update the worksheet 2008-09 in the "Tangible Capital
Assets" workbook and it automatically update the "Cap 11-Tangible Capital
Assets" worksheet in the other workbook.

Can someone please help me?

Thanks