I have certain excel file that i want to be able to write a macro in order for it to extract certain information from certain cells on different sheet. In other words, i want cell A2 from each of the three different worksheet i have under the different file. And have those data automatically update a master excel or access file whichever might be easier. This is urgent. PLease help.
Thank you very much