Pulling rows from multiple sheets and pasting values in appropriate matching headers in a summary sheet.

[kofafa]

Hi there,

I am new to VBA and I need help finding a code to extract data from rows in various worksheets with different names, except for the data sheet. The extracted data needs to be pasted and sorted on a summary sheet located at the beginning of the workbook. To give you an idea, I want the code to automatically extract the corresponding row when any value is added to Column B from any worksheet. It should only extract cells under headers with green color and paste them under matching headers colored green in the summary sheet. Can you please assist me with this? Thank you.

 

[kevin9999]

That is now a significant increase in your requirement. As such, you should start a new thread.

 

[kofafa]

That is now a significant increase in your requirement. As such, you should start a new thread.

Thanks i will do that. much appreciated.