I have a workbook with 2 spreadsheets I'd like to tie together. The first
sheet has several columns, one consisting of vendor names, and others with
amount of invoice, invoice #, etc. I'd like to be able to consolidate only
the rows that have an invoice amount inputted (along with other data, such as
vendor name and invoice number, etc.) onto the other sheet. I'd also like
the data to show up sorted in by vendor name on the second sheet.

Is this something that can possibly be done?

Please help! Thanks in advance.