Copy/paste with offset and transpose

Hi,
I have a VB query which I assume is not very complex, but which I nevertheless still have not been able to resolve.

I have an Excel tool where users enter in data for one case at a time. The data consists of values on a set of variables. An incrementing case ID gets is assigned to each case. When the user has entered data for a case, the case input data (variables and Case ID) then needs to be copied and pasted into a separate worksheet, where case data is stored row-wise. A copy/paste macro is therefore required, which transposes the data, offsets by a number of rows equal to the case ID, and also uses the "paste values" function.

I have attached a stripped down version of this tool for illustration.

Any help much appreciated!