Quit trying to USE a spreadsheet to control data! Use a DATABASE!
Build a table. Build a form that places the data into the table. Fill out the form. Report on the data! It is that simple!
You may have to pay for it, but that is the cost of doing business isn't it? If it saves your PM time for billable time, doesn't that seem worth the cost?
Excel is for calculations, you are storing values!
I will be more than happy to Script a Database in SQL for you, but you have have the license. Cost of doing business! BTW, as long as it doesn't get ported to multiple machines (like in a Datacenter) the license is FREE!