I have a Summary worksheet that summarizes parts and labor entered on other
worksheets. One section should pull data from the Misc.Parts sheet. I would
like it to only pull data for lines that have a number 0 in cells A17:A216,
and populate the next blank line in the section. When the data populates, it
should pull from Col A on the old to Col A on the new, Col B to Col B, Col D
to Col H, and Col G to Col F. If there is not another blank line to use, it
should error or insert a blank line to be filled.

I have tried using some of the formulas in the posted questions, but nothing
even comes close. I would appreciate any assistance you can offer.