Vlookup to create report

[bmpreston]

Looking to pull a range of a VLOOKUP if a value exists.

Pull this to a dynamic report from multiple sheets onto one consolidated sheet.

Please see the example:

Text	text	text	value to match
foo	foo	foo	-1
bar	bar	bar	0
foobar1	foobar1	foobar1	-2
helloworld	helloworld	helloworld	4

<tbody>
</tbody>

John Snow <--worksheet name

text	text	text	value to match
foobar1	foobar1	foobar1	3
anothervalue	anothervalue	anothervalue	-4
something	something	something	2
more	more	more	-2

<tbody>
</tbody>

Elon Musk <--worksheet name


This is two example sheets of 12 in a workbook.

I need to put the name of the worksheet in a cell; add a few rows for gaps; then bring over the rows with a negative number; few rows, then the new worksheet name; then that sheet's negative values.


The Results would look like this:

John Snow
foo	foo	foo	-1
foobar1	foobar1	foobar1	-2
Elon Musk
anothervalue	anothervalue	anothervalue	-4
more	more	more	-2

<tbody>
</tbody>

Thanks!