Merging Multiple Excel Worksheets into Master

there are many ways

http://office.microsoft.com/en-us/excel-help/create-and-manage-links-to-other-workbooks-HA001054812.aspx
http://www.keynotesupport.com/excel-linking-worksheets.shtml

see this links to easy understand

Thanks but linking is not what I need as additional info will continue to be added to the sheets in the files. I need to be able to run a macro automatically that will scan all existing workbooks and sheets for updated info and then place the newly modified and/or new data into one file called master.

Then, my ultimate goal is to create a dashboard from the master file and display in SharePoint 2007.

http://office.microsoft.com/en-us/excel-help/consolidate-multiple-worksheets-into-one-pivottable-report-HA010226585.aspx?CTT=5&origin=HP010095249

al lthe best

hi,

I'm not sure if this will help or not (& it doesn't answer all your questions), but since you are consolidating info from multiple files into a single file Rin De Bruin's free addin may help. It is quite flexible & easy to use and can be sourced from his site: http://www.rondebruin.nl/merge.htm

hth
Rob

This was excellent info; I loaded the add in and that worked with no issues and now have enabled the camera tool. I'll begin creating the dashboards in Excel and see how I can get them to work in SharePoint 2007.

Thanks for the Grade & good luck with your dashboards :-)