Hi there.. not sure if I am explaining this correctly. What i have is Sheet 1 called tracking. This has all the information about all files being tracked. Then i have 5 other worksheets specific to each type of file.

I want to put "4" in the last cell of row 1 and have that row copy and paste into worksheet 4
then 2 in the next one and have that one copy and paste into worksheet 2
etc. I have tried the VBA codes online and cant seem to find one that works.

Thanks in advance, guys