Create new table with data from multiple tables according to criteria

Hi Guys,

Monthly, I receive a file with multiple sheets on it (but with the same sort and format).
This sheets contains expenses charged into multiple WBS (Cost Centres).
I'm working on a project, who has specifics WBS (listed in a sheet called "WBS Needed".

The challenge here is to retrieve those rows from the other sheets that meets the criteria of my list of "WBS Needed", and show, in a new worksheet, a new table just the expenses that corresponds to my project (or my WBS).

Attached is my workbook for reference.

The criteria key is WBS number, but I don't know how to list, on the a new sheet, those rows from different sheets that meets the criteria.
(one below the other)

Can be with a Macro maybe? or is there a formula that make things easier?

Rows quantity may vary each month.

Many thanks!

Lean

It's quite difficult to work out exactly what you're after here. You can perform a VLOOKUP function in your WBS Needed sheet along the lines of:

Please Login or Register  to view this content.

...but this only finds 2 matching WBS numbers.

Any chance you can advise what you expect to see returned from a formula or macro?

I need a new sheet, with the same format as the other, but just with the Expenses charged on my WBSs. Like a filtered table.