copy/import data from a table in body of outlook email to excel

I'd look in to building connections between workbooks. I'm no expert on this, but I have seen it done.

I would start by building a different worksheet for each of your twelve staff members. Save these in a subfolder wherever your master spreadsheet is (or any safe network place that you can always access. If you need to make updates on the road or out of the office then maybe sync this to dropbox or something). Every month instead of sending the master spreadsheet to everyone, just send them their individualized spreadsheet to fill out and return to you. When they return their personal spreadsheet replace the corresponding file in the subfolder with the updated one.

Then build a connection between the master file and each of these subfiles. When the subfile is updated / changed then all you should need to do on the master is click "refresh data" and presto you should be good to go.

This should work pretty nicely if the data layout doesn't change too much. If there are radical changes to the formatting then this might be trickier.

This might be of some help: http://office.microsoft.com/en-us/ex...010167227.aspx

Good luck!

Edit - Instead of sending out 12 workbooks to 12 employees you could do 1 workbook with 12 tabs to each of the employees. Then build connections to each tab.