Writing a macro to collect data (selective) from multiple sheets to a summary sheet

Excel Forum Copy.xlsx

First of all I am new to this site. Hello and thank you for reading this post. I am not brand new to excel, but new to this issue. I am currently seeking help. I have a workbook that has many sheets. I have a summary sheet on sheet 1. The info on sheet 2 is in the same place on sheet 5000. I need to:

1) set up a macro to obtain the information
2) take that information and place it on the summary sheet in its respective place.
3) continue to do that until all sheets are completed and all information is in the summary sheet.
4) be informed on how to place it in the excel document for this years data and then next years workbook.

I have included a sample workbook of the information complete with the summary sheet with the headers. I have also highlighted the data with respect to where it goes on the summary sheet.

If this site allows someone to reward another for helping, I would love to contribute two dinners for someone. If the site does not allow this action it would be greatly appreciated if you could assist.

If there is somewhere online where it could walk me through the process that would be ok with me as well. I am trying to make things easier at work on myself and others and this would save hundreds of hours of work. So please please please help me. Thank you thank you thank you for all your help in advance.

I appreciate your help in the matter but I wouldnt have a clue on which one to select let alone how to implement it into my workbook. I really need a step by step on this issue.

ok i see the code now sorry bout that. how do I implement it. I set up my developers ribbon and have played with recording macros and such but have not set up one yet. Please help and you got the dinners bro haha, thanks

Thank you very much. You assistance helped me so much. I dont have a paypal account, but my brother does but he outta town at the moment. He will be back in town bout 4 days and I will send you some moolla then bro. Again thank you very much for being such a good person and helping a excel handicapped person out. I actually used a different process to upload the code. I opened vba, then clicked sheet one, copied the code into the field then ran the code from vba. it ran for a sec and then was complete. Thanks