Also, I want this function to find the last row of data on a specific sheet and pase a new selection right underneath it. I think I have this part down though, but I'm not sure, I know there has to be a more efficient way than what I've done.

Thank you, any help on this would be greatly appreciated.