Using ROWS, Index and Match - out of my depth

So, I've been using the formula below which works perfectly - however I need a very similar thing, but with a couple of changes, and I can't work it out.

{=IF(ROWS(C$15:C15)>$G$7,"",INDEX(Pipeline!A$1:A$316,SMALL(IF(Pipeline!$A$1:$A$316>=$F$1,IF(Pipeline!$A$1:$A$316<=$H$1,ROW(Pipeline!$A$1:$A$316)-ROW(Pipeline!$A$1)+1)),ROWS(C$15:C15))))}

Bit of background.

It picks up information from another sheet (without the need to filter on the original sheet) and returns anything between the two dates. It's only particular columns that need to be displayed on this sheet.

I want to do a couple of things slightly different in the formula.

At the moment it picks up the date from column A, however I want it to pick up the date from V.
I also want to "filter", without using the filter. There is another column with the words won and not won - I want it to pick up only those with "won"

Also, the original information is subject to change, and, rows are added at the top row. which means the cells in bold move down a2 if one row has been added etc - I've been told about Indirect formula but cannot fathom how to make sure it keeps looking at a2, no matter how many rows are inserted.

I've spent hours on this - and cannot work it out! Any help is much appreciated.

I'd like is to collect the date from v instead of a (under a different heading). The date is collected for something upon entry into the system (a) and then v is once the process is completed.

Arghhh - I've dragged the formula down around 200 cells (maximum returnable) but hadn't considered doing iferror in that position (not sure why) - thanks!!!

It works!!! I'll have chance to test it tomorrow but I think it looks great and works. The numbers finally match!!!!!
Overjoyed. You sir, are my hero.