Just a follow up, this is working great!
I used the script provided in the solution that George provided and modified so it would actually restore the database instead of giving me an output.
SET @cmd = 'RESTORE DATABASE ' + @dbName + ' WITH RECOVERY'
Now...instead of restoring from a local drive, I want to set up restores from a unc path (IE: our production backup location)
I have this setup as a hidden share (\\hostname\d$) and the database backup folders are located in that area. But for some reason SQL Server cannot 'find' any backups even though they are there.
I've mapped a drive on our test environment to make it appear as a drive letter but still cannot get SQL Server to find the backups. I'm logged into SQL Server as a domain administrator.