Need Assistance Building Something to Pull Data Fields from a Workbook with Multiple Sheet

[gloftis1999]

Hello, I need a bit of assistance building a flow.

I need to read every sheet from multiple excel files (Company profiles) and pull the Jurisdiction, Website, Login ID, and Password from each sheet. There could be multiple in a sheet (AL and CO sheets for example).

I have attached just one of about 30 workbooks I will need to do. And there could be up to 60-70 sheets in any given workbook. The goal is to consolidate every login from each workbook into a single excel sheet.

No matter the sheet, the order should always go jurisdiction, website, login ID, password, and then if this sequence happens again in the same sheet, its for a different login.

The complexity is beyond my skill level. Any help would be appreciated!

[binuacs · Accepted solution]

@gloftis1999 one way of doing this with the help of batch macro

[abacon]

@gloftis1999 LIke @binuacs did, the batch macro method is your best bet. Does this macro I created help with what you need?

Dynamic XLSX Input Tool 

It takes a directory of excel files and consolidates them into one data stream regardless of sheet name, if each workbook has tabs that are needed in the data this will work perfectly for you (as long as the data starts on the same line in each one). I have used this functionality many times and it is very helpful to know how to do it.

Hope this help!

Bacon

[gloftis1999]

I was able to get this working to produce the desired output. Thank you very much!