Ranges of numbers from source sheet to individual sheets

[troych]

Hi there, first post, rather complicated (at least for me) problem. Is this possible the way I want?

I've got a sheet with ranges of numbers for each calendar week, I then have seperate sheets for every calendar week (week1, 2, 3 and so fort). Is it possible to automate filling in these numbers from my source sheet to the individual weekly sheets? At the moment this would be a rather tedious copy and paste marathon.

Mappe2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
2	04.01.2020	05.01.2020	06.01.2020	07.01.2020	08.01.2020	09.01.2020	10.01.2020	11.01.2020	12.01.2020	13.01.2020	14.01.2020	15.01.2020	16.01.2020	17.01.2020
3	3'155	3'563	1'443	2'446	2'285	2'845	3'868	4'185	4'506	2'316	2'204	2'858	2'859	4'431
4	Week 1							Week 2
Sheet1

I've copy pasted the numbers for the example now.

Mappe2
	A	B	C	D	E	F	G	H	I	J	K
1				WEEK		1	YEAR			2021
2	DATE			04.01.2021	05.01.2021	06.01.2021	07.01.2021	08.01.2021	09.01.2021	10.01.2021	Total
3	DAY			Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
4				3'155	3'563	1'443	2'446	2'285	2'845	3'868
Week 1

Cell Formulas
Range	Formula
D2	D2	=DATE(J1, 1, -2) - WEEKDAY(DATE(J1, 1, 3)) + F1 * 7
E2	E2	=D2+1
F2	F2	=D2+2
G2	G2	=D2+3
H2	H2	=D2+4
I2	I2	=D2+5
J2	J2	=D2+6

Cells with Data Validation
Cell	Allow	Criteria
D4:K4	Whole number	between 0 and 10000000

I'll be happy to provide additional information if needed.

 

[AlphaFrog]

Your example data is using two different years.

You could use the HLOOKUP function

Week1 D4

=HLOOKUP(D2,Sheet1!2:3, 2, 0)