Pull Data (text) from Multiple cells in multiple sheets to create a summary master doc

Question

I have a large Excel file, with many tables containing alot of information about services my company provides. Each sheet is uniform.

In one tab, I want to have one row of data with top line info relating to each supplier, as a quick 'go-to' sheet. Heading on the master sheet will come from sections of the individual sheets.

Anyway to automate this?

Answer 1

You are welcome:) You may also give feedback on it.

Answer 2

This works great, thank you!

Answer 3

Is it possible to add a help column in each sheet to tag rows you want?

Then you can use VSTACK&filter formula&3D reference

=WRAPROWS(FILTER(VSTACK('Service Name 1:Service Name 2'!B3:B23),VSTACK('Service Name 1:Service Name 2'!F3:F23)=1),10)

Test file is sent in private message.

Private Messages - Microsoft Community

Answer 4

Hi there, see link below.

Sheet 1 and 2 are samples of the services and the 3rd sheet is the master sheet. There will be a lot of service tabs.

Sample for Microsoft.xlsx

Answer 5

Could you share a test file with some dummy data in it and show us an expected result? Then I can give suggestions on it.

For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.

*Please make sure you have removed any sensitive or private information in the sample file before uploading.