How can i empty data by reference by sheet name?

Hello @lovepong66

You can try invoking VBA

dim ws as worksheet

Set ws = Sheets("Sheet1")

ws.Cells.Clear

Thanks,
Prankur