So I've been challenged to come up with a solution

1- We download out of software program (that has a set of reports that are useless) a set of data.
2- Data is massaged slightly-- add a couple of columns etc, and put into a pivot table. One of the columns is "status". That Status will be show in the pivot table
3- The pivot table is sent out to a manager. We want the manager to be able to update the "Status" field as necessary, but not in the data fields
4- Rinse, repeat.

So, the data out of the software program does have a UNIQUEID, so I will be able to do the download, then upload any new information into existing spreadsheet using vlookups etc. So each month I will get the download, upload onto the spreadsheet, create pivots, and send to the manager. He then will make comments and send back (more than likely, I will set up the file on a common drive, and send links rather than the file, so I don't have to worry about version issues)

So, I'm thinking what I need to do is some kind of form. The manager will select the status he wants, then click a button on the toolbar, that will launch form. He enters his data, and then saves, the status is then updated on the main data page, and the pivot table is refreshed.

So, any thoughts on the best way to do this? Is it a macro? VBA code? Impossible? Would I be better in ACCESS?

(I've decent knowledge of EXCEL, but am a little lost with this)