Trouble with compiling 2 ranges into a summary

[RumJellybean]

I have looked all over the place but nothing seems to work for me.
In detail, I have a quote book i made with two sheets for different types of items on them. For example:

Sheet 1 is for wooden items, and sheet 2 is for metal items.
So after i enter all the items on sheet one and sheet two, I want to be able to combine all the items from both sheets into one summary sheet that i can send to the customer.

I tried consolidate, and messed around with pivot tabels but it didnt seem to be what i'm looking for.

 

[RumJellybean]

!PROBLEM SOLVED!
This worked great! Only problem was the #n/a error which is easily fixed. Thank you so much. I can finally finish up my quote book.

Bob Umlas-Excel MVP came up with this!
You can write this function macro:

Option Base 1
Function NoBlanks(ParamArray rgs()) As Variant
Dim v() As Variant
For i = LBound(rgs) To UBound(rgs)
For j = 1 To Application.CountA(rgs(i))
num = num + 1
ReDim Preserve v(num)
v(num) = rgs(i)(j)
Next
Next
NoBlanks = Application.Transpose(v)
End Function
then in the worksheet, select all the cells which
could contain the result, like Sheet3!A1:A25 and
enter this via ctrl+shift+enter:
=noblanks(Sheet1!A2:A10,Sheet2!E20:E30)

If you select too many, the last few will show #N/A but
you can suppress this by conditional formatting and use
ISERROR function to turn the font white so it won't show.