Collect data from multiple sheets into a Summary Sheet

**Fuhgawz** · 10-04-2012, 07:54 PM

I am looking for a macro that will look through 31 sheets and check to see if any information has been placed into cells B7:H25 on those sheets. if there is any information in these cells I need it copied and placed on a summary sheet with the sheet name (represents the date) as well as column A which holds the time. It only needs to pull information if there is data present but data may not necessarily go row to row and may skip. I have a partial macro already added that I found while looking through the forums and have left it in. The summary page I would need to have a button to run the macro as well. If anyone can help me I would be much appreciative.

**venkat1926** · 10-06-2012, 06:17 AM

the mdofied macro is

Please Login or Register  to view this content.

**Fuhgawz** · 10-06-2012, 08:50 AM

Thanks for the macro. However after testing it appears to only appears to pull data from the last sheet in which data was inserted as opposed to scanning all the sheets and copying data. it is possible that every time slot could not be used and will need to scan and omit out any row that does not have data starting in Column B.It also needs to pull the data from a5 or the sheet name from which it was pulled.

**mike7952** · 10-06-2012, 09:29 AM

Give this a try. Im assuming a value will be in Column b

Please Login or Register  to view this content.

**Fuhgawz** · 10-06-2012, 09:43 AM

Thanks Mike this macro works perfectly.

**titusingh** · 10-10-2012, 12:56 PM

HI I neede to copy data only from specific sheets. The above macros pull data from all worksheets other than Summary. Can someone assist in a macro where I would be able to specify the sheet names from where data is to be consolidated into one sheet. The 3 theets have identical data i.e same columns, but only rows will change each time. The sheet names will also remail static thanks