Attribute table to excel sheet

I am thinking about trying to figure out how I would go about this situation, have not looked into it much but wondering if anyone has experience doing the same thing...

Basically, I have a model that creates about 20 shapefiles, all have an 'Area' field that I have added and calculated (as they are shapefiles and not in a GDB).

I also have an excel spreadsheet that lists all of the shapefiles, and the area values of each.

I would like to be able to have each shapefile write its 'Area' value to the corresponding block in the (single) excel spreadsheet. Each shapefile has a unique name, and all are located in the same folder. Each shapefile has been dissolved, so that there is only one record in each attribute table.

I am using 10.0 with an ArcInfo licence. I am also using MS Excel 2003

You won't be able to edit an Excel table within ArcMap, so there'd be no way you can write values to the Excel table through ModelBuilder or any other process within ArcMap. You can export the table to a dbf or file geodatabase table, and then you'll be able to do field calculations on the table. As for your workflow, if I understand it correctly, it sounds as if you'd want to use an iterator, specifically the Iterate Feature Classes iterator. This will cycle through your shapefiles in a workspace, and then run the same process on each shapefile. After the iterator, join your feature class to the dbf or file geodatabase table, then use the field calculator to calculate the values from your feature class to the table.