VBA更高效/更清洁的方式来选择工作表并将变量分配给单元格

I am wondering if there is a more efficient way to do this which will compile quicker and look better/be less lines:I am wondering if there is a more efficient way