MIN & MAX VBA commands not seeming to work

I'm trying your suggested code now. Thank you!

One thing I'd like to ask is, on the INPUT tab on the worksheet I only want the rows outlined in red from the DETAILS sheet to be listed. It seems now when I run your code nearly 300 lines show up on the INPUT page, when I really want only the actual handful of rows that are outlined in red from the DETAILS page.