Vlookup with multiple sheets and multiple returns

[MTodorova]

Hi there!

So I am in a bit of a bind and need help figuring out the following:

I have 23 Worksheets.
All of the worksheets have the same headers in the same column locations
All of the worksheets have different criteria (names, dates, blank fields, etc.)

Worksheet 1
Col A - Building number
Col B - Apt Number
Col C - Name
Col D - Date Received
Col E - Date Printed
Col F-I - etc. etc.
COL J - "Pending" (I wrote in a formula that if the 2 dates of printed and received cells are "blank" then the lease is pending and this is what I need pulled).

I have about 22 Worksheets with different, not repeating data, save for the word "pending".
Worksheet 1 will have about 40 rows of data..which will be updated all the time and expand and change from "pending" to blank (if no longer pending) in column J...

So, what I need is the following:
Worksheet 23
I need a Vlookup formula (or formulas) to search all the previous worksheets and return any building number and apartment number (only - don't need the entire row but COULD return the entire row if easier) that are "pending" or have the word "pending" in that column J... Problem is that there may be multiple rows (not immediaetly one after another) that may be "pending"

I can manually update the fields and formulas, and would prefer a formula (or multiple) instead of a VBA.

Please help! Thanks!