using code to copy same range from different tabs

[ammartino44]

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)).........

[ammartino44]

It might be something fairly easy like looping through specified tabs, copying range into first specified column and then looping through column as you loop through range. That sort of makes sense but not sure how to write it.

[ammartino44]

Hello? Anyone?