Relative path in Automator
Instead of AppleScript, you could do it by adding a Run Shell Script module with this content:

for F in "$@"; do
    cp "$F" "${F%/*/*}/Folder1/Folder2/${F##*/}"
done 


Edit the names of Folder1/Folder2 to match your actual case.

Choose As arguments from the Pass Input: pop-up at right where it says to stdin.

$@ stores the full path of all files selected. $F is each individual file's path as it is processed by the for loop. The weird ${F%/*/*} is the full path of the file minus the file name and its parent folder name. The weird ${F##*/} is the file name itself.

Test first for safety!



The other way to do it, which I think would be easier in the long run:


Open a terminal window.
Type cdspace and drag the folder containing your files into the window. (This will paste in the path to that folder. Be sure to include the space after cd before you drag-and-drop.)
Type cp *Video* ../Folder1/Folder2
Done!