Splitting Data from 1 Sheet to Multiple Existing Sheets

Please attach a sample and will write you a better and faster code. To attach a sample, go to advance, then attachment.

Alright, I've attached that to the original post. Hopefully that helps to better describe my problem.

No, Metrics Prep is blank, so I do not know how many columns you want to copy and do not also know where the header is?
Please attach a sample, removing any confidential info.

I'm sorry about the confusion, but it has been sanitized, and the relevant data is included in column S, T, U, V, and W of the Metrics Prep sheet, as described in the OP.

By sanitized I mean I have removed confidential data, and I've retained a sample of the relevant data.

I'm sorry, I'm unsure of what's going on here, as I've now downloaded the attached example.xlsm file multiple times and each time the Metrics Prep sheet contains a sample of the relevant data in the cell range S1:W4. This is a small sample set on purpose. If the macro can be updated to work properly 3 rows is all that is needed to prove the validity.

There is no data included in the sheets other than Metrics Prep because the point of this macro is to move the data from the Metrics Prep sheet to the other sheets. The sheet I desire to move it to is included in column S, and the metrics in column T, U, V, and W belong in columns A, B, C, and D of each sheet. For example the S2 references the sheet directly following the Metrics Prep sheet by it's title. I would then like T2, U2, V2, and W2 to be moved to that sheet, whose title is referenced in column S.

If you're not seeing the data than I'm unsure of what's wrong, as it contains a small sample of the relevant data.

Cloud19,
I am sorry! It was my fault! Please accept my apology for giving you a hard time.
Since I did not see any data in columns A, B up to k, I thought it was empty sheet.
Please see attached.

No, you're fine. I apologize for being unclear about that in my previous posts. Thank you very much for assisting me.