Consolidate fields from multiple sheets into a single summary

Hi,
I am trying to create a summary spreadsheet by compiling fields from multiple excel files. I have attached an example of the output.

There will be over 1000 Detail input sheets. What is the best way to pick out the fields and paste them into the summary sheet? I have been able to do this for a single field, however I get stuck when I try to apply the logic to multiple fields.

Thanks in advance

Thank you very much for this. How can I adjust this to cater for fields that are not in rows? I have attached an example

Try

Please Login or Register  to view this content.

Thank you very much. I have tried to add more fields into the array and get the following error after it copies the first sheet:

Method range of object _worksheet failed

Originally Posted by ezzy85

I have tried to add more fields into the array

Show me the code that you changed.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

of course! thanks so much