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!

Sample Company Profile.xlsx

Desired Output.xlsx

Workflow

Accepted answers

binu_acs

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

Combine_Sheets_23072025.yxzp

All comments

binu_acs

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

Combine_Sheets_23072025.yxzp

abacon

@gloftis1999 LIke @binu_acs 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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703