Tables with dynamic validation lists

Hi all!

First off, congrats on the forums. I've come for several solutions, and answers & tips are usually there.

I come today with my first unresolved issue (which my gut tells me might be really easy, or absurdly complex). I am working in Excel 2010 (PC Version), and have a table with a data validation criteria (to create a list) that does not replicates itseft automatically when I add new rows to it. Weirdest thing is, another column of the table does have an equal data validation criteria which DOES replicate itself.

The validation criteria is as follows:

=DESREF(Validation!$E$2;MATCH(D2;Validation!$E$2:$E$126;0)-1;4;COUNT.IF(Validation!$E$2:$E$126;D2);1)

The table I'm having issues with is in the "Input" sheet of the attached file, specifically in column F. Column D has a similar validation formula, but does not present the problem (although I could not figure a way to eliminate duplicates from the dropdown lists).
If you need me to translate, I can do so. Also, if more details are needed, I'll be happy to provide them.

Thanks for any/all comments!

PS: The "Budget" sheet just shows #REFs, but it shouldn't be relevant I believe...