Bring Data from other sheet

Hello:

Please refer to attached file.
Data is at "Labor_Sales" Row 309 onwards.
Row 308 from Column N onwards is TimeRange eg : 8 to 9, 9-10, 10-11.....11-12 midnight.
Row 310 thru 316 is hourly Labor cost in column N thru cloumn AC

I have "HourlySales" Sheet hourly sales in row 3 thru 14 for each day.
Note :
1st day Sales is in column C
2nd day Sales is in column G
3rd day day Sales is in column k and so on.

I need to bring these numbers in cell M320 thru AC326

Let me know if you have any questions.
Thanks.

Riz

As you don't have any sales for the period 8-9 or 9-10 (or even after 10pm), then you don't need a formula for those columns. Put this formula in P320 of the Labor_sales sheet:

=INDEX(HourlySales!$A$3:$AA$14,COLUMNS($P:P),(ROWS($1:1)-1)*4+3)

copy this across to AA320, then copy those formulae down to row 326. For completeness, you might like to put this formula in M320:

=SUM(N320:AC320)

and copy that down. Note that your totals on row 15 of the HourlySales sheet are not correct - put this formula in C17 to show this:

=SUM(C3:C14)

Copy the formula into G17, K17, and so on.

Hope this helps.

Pete