Transfer data from multiple sheets into 1 summery sheet

Hi,

I am trying to collect information from random cells in multiple Excel files (200+) into 1 summery file.  
ex.  From Quote tab to Summery tab  (see attachment).
Example.xlsx
JuJuChiaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Patrick MatthewsCommented:
Can you try uploading that file again?  I am having trouble reading it :)
0
ydsonlineCommented:
If I understand you correctly all you would have to do is to go to the Summary Sheet and click in the Cell underneath the Column e.g. Quote Price, type the = sign then switch to the Tab e.g Quote tab and click in the Cell that you wish to display in the Summary Sheet and press Enter. This will create a direct link from the Summary Tab to the Quote Tab. The same applies for a Tab in a different Excel workbook. Make sure both workbooks are open then follow the same process as mentioned above.
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

yogi4lifeCommented:
Hi,

Made this VBscript which starts Excel and reads the cell information from all Excel files in the same folder that the VBscript is in. The REQUEST.XLSX is also necessary for the summary information. Depending on the number of Excel files it might take up to several minutes to consolidate a few hundred files...

You can start the consolidate.vbs by double-clicking from Windows Explorer or from the command-line.
consolidate.vbs
Request.xlsx
Request1.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JuJuChiaAuthor Commented:
Hi Matthewspatrick:
I have re-uploaded the file below.  Please let me know if you still have trouble seeing it.  

Hi Ydsonline:
Yes, you understanded the issue correctly.  The only problem is I am collecting 18 different information from different cells on over 200 Excel files.  (that's 18 x 200 = 3600 cells that I need to create a link to)  The good news is, only 3 forms are used.  That means I can obtain each information from a predictable location in the original file.  

Hi Yogi4life:
I will take a look at the files you sent.  Thank you.  
Example.xlsx
0
JuJuChiaAuthor Commented:
You are amazing, Yogi4life!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.