Transfer data from one sheet to another with different format and formatting

[ExIF]

Hi, this is my first post so please be gentle.

I am looking to create a fixture list from data i have in 2 other worksheets,

Fixture Generator and Results.

I was thinking the results page would be better to get the info from as it is already filtered (if 16 teams, 8 rows + 2 headers, if 9 teams, 5 rows + 2 headers etc.)

The thing is, the filter has it listed in a column....

How would i get the info, conditionally, to enter into the fixtures sheet so that week 1 would be to the left, then week 2 to the right of that, up until week 4, then start a new row of fixtures until it is complete. Possibly having a gap between the first half and the second half ????

I have uploaded the file so that you can view it.

Also is there a way of refreshing the workbook without recalculating the fixtures?

Eh, 1 other thing.... (possibly more to come).... i don't want to use macros for the time being, i have been reading up on vba and i would be interested in doing a new workbook with vba implemented but for the time being i would like this workbook to be completely macro free.

Thanks in advance

Graham