Hello,

I am working on building the following error checks into my worksheet via VBA and wondering if anyone could provide me with some simple and efficient code. My worksheet has about 40 detail tabs and a single summary tab and a single error check tab.

1. The first error check I would like to do, pulls a value from a cell on each detail tab and pastes it on the error check sheet. I need this to paste both the sheet name it is pasting from along with the value. (I am using this to ensure the correct number of values appear on my summary sheet without having to count the number of line items on each tab seperately)

2. The next check I would like to do simply counts the number of tabs in the workbook if your thier name isnt 'Summary', 'Error Check' or any other tabs I define.

Thanks in advance. I know this seems like simple fiuunctionaity but I have not been able to get anything to work without significant performance hits.

SB