Copying based on sheet order. Hello. I would like to copy a range from the fourth sheet (in terms of order) to the second to last sheet.

The range that I want to copy in each tab is BC6 to the last row. Then I want to take each of these ranges and copy paste values into the specified column. See below. So, column C below is the first column, so I want the range from that first tab to be copied into column C, and so on.


In the last tab, I have this code to determine the space that I want to copy the range from the tabs into.

Last_Col = ActiveSheet.Cells(5, Columns.Count).End(xlToLeft).Column
Worksheets("Total").Range(Cells(6, "C"), Cells(275, Last_Col)).........