making a summary sheet combining data from multiple workbooks

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Hi Elsie,

I think you are looking for the Power Query tool that is a Microsoft Add-In. It will allow you to pull in data from multiple workbooks and make a single worksheet from them.

https://www.microsoft.com/en-us/down...0-5985b53865f8

https://support.office.com/en-us/art...9-22554d0bcb1c

Thanks. I've attached a sample workbook. Basically, we have individual workbooks for each patient labeled LastName.FirstName.YYYY.MM.DD.
I want to be able to run a report that lists all of the medications under the MEDREG from the sample workbook tab into one file and format it something like in the "med inventory sample" book I also attached.

Any help would be appreciated!

Thanks,

Elise

So to let me understand the process correctly

copy information from worksheet ("MedReg") from Patient.name File and paste it into Med inventory Sample at the bottom of the file

something like the attached file?

This thread...
https://www.excelforum.com/excel-gen...worksheet.html
is pretty similar, you might want to monitor it as well?

The coding for the actual copying itself isn't very complex for the single workbook

though some structure would need to be applied so the code can run effectively for many workbooks
is the patient workbook open at time of running or did you want excel to have an "open File" dialog to choose what file to open?

if the later did you just want excel to open every single file in the folder and apply the code to it ...instead of opening 40+ books and running code every single time?