Repeat Columns on Multiple Sheets

Hi all,

I have an interesting challenge.  I am making a month ending accounting financial closing workbook.  The first sheet is a listing of active project names and several columns helping to create a month end closing Work In Process calculation.  Essentially it takes the total revenue as one column and the billed to date as a second to calculate the percentage of completion.

There is a projected cost column and an actual cost column.  Based on the percentage completed it spits out a journal entry to make in our accounting software to treat any missing cost as "Work In Process" and provide good financial statements.

I need to add a separate calculation for a month end journal statement moving sales between accounts in our accounting software.  Since the projects in this sheet are the only open ones the intent is to run this new set of calculations on the same set of projects.  As such it would be hugely beneficial if whatever we enter on the left as our list of columns repeats on every sheet.  THis way whatever projects are open in a given month show up in both tabs for our calculations.

Any ways on doing this?  My first thought was to just use an = formula but if the user enters or deletes a line it breaks the spreadsheet