Extract data from multiple sheet to new sheet in same workbook

Question

I have a workbook with 6 sheetsMaster Tank ListLess than 3000 WC3000 WC3200 WC3400 WC3700–5000 WCI need to pull data from the 5 WC sheets (excluding the Master Tank List) into a new sheet, keeping the same column names, except for the Quantity column, which I want to exclude.Can someone please guide me on how to do this in Excel?&nbsp;

m_tarler · Answer

can you attach a sample (with no private or confidential info) or make it available in a web sharing site like sharepoint, onedrive, google drive.

Since we don't know how the data is arraged in those sheets or how the sheets are arranged the following may or may not work:

=VSTACK('<3000 WC:3700-5000 WC'!B2:G2)

or maybe

=VSTACK('Less than 3000 WC:3700-5000 WC'!B2:G2)

not sure how your sheet is actually named and you need to replabe B2:G2 with the actual location of the data on those sheets

msts0022 · Answer

I need to pull data from main Master Tank list, so that data in Summary Excel sheet in same workbook can be auto pulled all time new info added to main sheet for -

Diff tank types (column A)

Less than 3000 WC

3000 WC
3200 WC

3400 WC

3700–5000 WC

In columns B should calculate Quantity for each type of tanks from Column A (from main Excel sheet) and columns C D E F G in Summary sheet should pull data from MasterTank list sheet columns - F H I K L, also column K should calculate value based on Tank size Quantities $1000 for Less than 3000 WC and $1500 for rest all Tanks types.(if Less than 3000 WC tanks are 20 types so K column value for this tank type should be $30000 and so on for rest columns.)

Forum Discussion

Extract data from multiple sheet to new sheet in same workbook

2 Replies

Resources