Using Data from another Sheet (HELP!)

[FilipT]

Ok so here's what I need to do. I have a table of data on a particular website, the link just shows a table of data and nothing else. It gives values in 5 columns and 6 rows which basically has the format of one row displaying the date, the next row the value, and then the next row the next 5 dates and so on for a total of three pairs of data/value (6 rows). What I want to do is have this data automatically fill a spreadsheet, then in ANOTHER spreadsheet, use the data from the original to manipulate it such that I can recreate a new table with 7 columns (for everyday of the week) and rearrange the data so that where it has the date in the original spreadsheet, it would display the date AND the weekday at the top with the corresponding value below. Any help would be greatly appreciated

 

[FilipT]

Just to clarify, this is essentially what I want. Btw the format of the date is M/D/Y so there would have to be a way to check what weekday that falls under if thats possible? This is essentially what I want:

if A4 is Monday, put in A4(sheet2)
if A4 is ... Sunday, put in G4(sheet2)

if B4 is Monday, put in A6(sheet2)
if B4 is Tuesday, put in B4(sheet2)
if B4 is ... Sunday, put in G4(sheet2)

If C4 is Monday, put in A6(sheet2)
If C4 is Tuesday, put in B6(sheet2)
if C4 is Wednesday, put in C4(sheet2)
If C4 is ... Sunday, put in G4(Sheet2)

If D4 is Monday, put in A6(sheet2)
if D4 is Tuesday, put in B6(Sheet2)
If D4 is Wednesday, put in C6(sheet2)
if D4 is Thursday, put in D4(sheet2)
If D4 is... Sunday, put in G4(sheet2)

If E4 is Monday, put in A6(sheet2)
If E4 is Tuesday, put in B6(sheet2)
If E4 is Wednesday, put in C6(sheet2)
if E4 is Thursday, put in D6(sheet2)
If E4 is Friday, put in E4(sheet2)
If E4 is... Sunday, put in G4(sheet2)

If A6 is Saturday, put in F4(sheet2)
If A6 is Sunday, put in G4(sheet2)
If A6 is Monday, put in A6(sheet2)
If A6 is ... Friday, put in E6(sheet2)

If B6 is Sunday, put in G4(sheet2)
If B6 is Monday, put in A6(sheet2)
If B6 is ... Saturday, put in F6(sheet2)

If C6 is Monday, put in A6(sheet2)
if C6 is... Sunday, put in G6(sheet2)

If D6 is Monday, put in A8(sheet2)
If D6 is Tuesday, put in B6(sheet2)
If D6 is ... Sunday, put in G6(sheet2)

If E6 is Monday, put in A8(sheet2)
If E6 is Tuesday, put in B8(Sheet2)
If E6 is Wednesday, put in C6(sheet2)
If E6 is ... Sunday, put in G6(sheet2)

If A8 is Monday, put in A8(sheet2)
If A8 is Tuesday, put in B8(sheet2)
If A8 is Wednesday, put in C8(sheet2)
If A8 is Thursday, put in D6(sheet2)
If A8 is ... Sunday, put in G6(sheet2)

 

[FilipT]

I don't need to add the Weekday name in the cell along with the value of the date anymore as I made a new row in my new sheet that already has the weekdays listed, so all i need to do is just copy the cell into the appropriate location on the other sheet based on what weekday it falls under. I saw this function "weekday(date, vbmonday)" but I'm still not sure how to write a code for that if statement and where to put it