I have a workbook with several sheets attached to it.
All my sheets perform as I want except 1.

I have a data sheet that has several data entry fields with different dates and amount of players.
i need to get this info into a 2nd sheet without doing a copy and paste.

I need to transfer the Week, Players, P, HH, and F/F fields into sheet 4:

Week March 13, 2015
# Players 21
Name January 29, 2016
13
Pld P HH F/F
x
x 4 $25
x 2 $15
x 3 $20
x 5 $40


x 7 $90


x $16
x
x 6 $50 $26




x
x 1
x
x

My problem is that WEEK and PLAYERS change week to week. I'm tired of "Copy and Paste". I need the first sheet for other calculations.

Can anyone suggest a way to do this?

Thanks in advance.