You need to make a folder called The Sims 2 in the same folder that the Ultimate Collection is in and copy your downloads folder into it so that the HCDU will recognise it
It should look like this- C:\Users\(your computer name)\Documents\EA Games\The Sims 2\Downloads