Hi
Seeking someone help to create VBA code. I have data in one worksheet (Active worksheet)

starting from B5 (right column not fixed, end of row not fixed)

I need VBA code to open specific folder ( desktop) and last modified Excel file, in last modified Excel file, I need to paste this data on Sheet "TB" on row C5.

After completion of pasting,

I need to rename the excel file with "-1"( example if file name is "sample", I need to rename as "sample-1"

Please help me to create VBA code