Yes, you can do that with VBA, which is built in to Excel, and as you want to "maintain a summary spreadsheet" then you may as well use Excel for it !!

Hope this helps.

Pete