You say that all column headers are the same so it would be feasable to pull
in similar cells in each workbook based on the same cell co-ordinates but in
different workbooks i.e.

='[Cathy.xls]Sheet1'!$D$4+'[Laura.xls]Sheet1'!$D$4+'[Tonya.xls]Sheet1'!$D$4
etc

"Ann" wrote:

Thanks for your feedback. Yes, four workbooks could be employed, but I still
need to pull the information into the master worksheet. Do you know of a
formula or macro to accomplish this?