Greetings
I wanted to copy data from multiple worksbooks to a master worksheet, the workbooks are in same folder but have different names and I want to copy data from the Cells E17 B28 B29 B30 B31 B32 to my master sheet the data in cells E17 should be in a separate column and the data in B29-32 should be in their own respective columns in the master work books. I have no experience coding in VBA and I have to submit my work in 5 days to any help would be deeply appreciated.
if anyone can suggest a VBA macro for the same.