How to Process all Excel Workbook in one Folder and Paste into a Master Workbook

Hey guys,

If I am asking too much with the below then just a macro that will open another WB (through prompt) and paste vaules into master will suffice and I will try to make the rest work. Please helpSo I have seen several different solutions for a macro to open Excel Workbooks, process and or copy data from it and then returning the results to a Master File. But no matter which way I try, I cant seem to get it to work. I haven’t had to write my own VB code since 2000 in college. I destroyed all my work with code snippets pasted and tweaked inside of the Macro mod. So bad that I am embarrassed to even show a sample of my codes( AND )