In addition to posion's explanation you need
to understand how the bash handles wildcards.
Those aren't handled by cp, but by the shell.
That is, if you specify something like /mnt/cdrom/*.*
the shell will build a list of files, and since you omitted
the destination on the command-line, cp will then
assume that the last file of that list is the target for
your copy-process ....