Macro Required to copy information from one sheet to a specific location in another - based on criteria

[JANGLE]

Hi,

This is my first time posting, so I apologise if I don't provide enough information. I'm uncertain if this will be possible with VBA/ Excel but it's worth a shot.

I am looking for a Macro that would look into one sheet and update/ populate a second sheet based on values.

here is what I'm trying to do;

1. Sheet2 is updated for "new projects", and existing tenders are updated for "Probability" as we come closer to due dates.

HIGH FOCUS PROJECTS
	PROECT NUMBER	PROJECT NAME	Probability	Project Details	Notes	Location	Tender Expected	Expected Start Date	Estimated End Date	Estimated Value ($M)
Urban	33	Project 33	5%	AAA	XXX	Location 1	Dec-17	Feb-18	Feb-21	1,000
Infrastructure	34	Project 34	50%	BBB	XXX	Location 2		May-18	Oct-18	2,000
Infrustructure	35	Project 35	25%	CCC	XXX	Location 3	Dec-17	Feb-18	Jun-18	3,000
INVITED/ADVERTISED TENDERS
	PROECT NUMBER	PROJECT NAME	Probability	Project Details	Notes	Location	Tender Close Date	Expected Start Date	Estimated End Date	Estimated Value ($M)
Urban	41	Project 41	20%	DDD	XXX	Location 4	25-Sep-17	Jan-18	Mar-19	4000
Infrastructure	42	Project 42	20%	EEE	XXX	Location 5	15-Sep-17	Dec-17	Jun-18	5000
CURRENT TENDERS
	PROECT NUMBER	PROJECT NAME	Probability	Project Details	Notes	Location	Tender Close Date	Expected Start Date	Estimated End Date	Estimated Value ($)
Infrastructure	51	Project 51	50%	FFF	XXX	Location 6	TBA	TBA	TBA	6,000
Infrastructure	52	Project 52	70%	GGG	XXX	Location 7	Mid Aug 17	Nov-17	Jul-17	7,000
TENDERS PENDING
	PROECT NUMBER		Probability	Project Details	Notes	Location	Tender Submitted	Expected Start Date	Estimated End Date	Tendered Value
Urban	61	Project 61	10%	HHH	XXX	Location 8	18-Aug-17	Oct-17	Nov-17	8,000
Urban	62	Project 62	15%	III	XXX	Location 9	11-Aug-17	Oct-17	Jan-18	9,000

<tbody>
</tbody><colgroup><col span="6"><col><col><col><col><col></colgroup>

2. I then need the following to be moved into sheet 1.
a. The macro to determine if any Probability percentages have been changed on existing projects and if so, update probability percentage
b. The macro to determine if new projects exist in the sheet2 list when compared specifically against the "Unsecured" - "Revenue by full contract value" section in blue only
c. If new projects exist, the macro to insert the new projects after either D16 (i.e. start at D17 for Infrastructure projects), or start after D18 (i.e. start in D19) for Urban Projects. These locations will need to change each time the sheet is updated due to this being an expanding list.

Secured/ Unsecured	Forecast	Sector	Project #	Project Name	Opportunity	Contract Value Total	Forecast Margin	Jan-17	Feb-17	Mar-17	Apr-17	May-17	Jun-17	Jul-17	Aug-17	Sep-17	Oct-17
SECURED	FORECAST REVENUE	URBAN	12	Project 12				$1,000.00	$2,000.00
			13	Project 13
		INFRASTRUSTURE	15	Project 15				$100.00	$100.00	$100.00	$100.00	$100.00	$100.00	$100.00	$100.00	$100.00
			16	Project 16					$200.00	$200.00	$200.00	$200.00	$200.00	$200.00	$200.00	$200.00	$300.00
	FORECAST COST	URBAN	12	Project 12				$100.00	$100.00	$100.00
			13	Project 13				$100.00	$100.00	$100.00
		INFRASTRUSTURE	15	Project 15				$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$0.00
			16	Project 16					$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00
	FORECAST MARGIN	URBAN	12	Project 12				$900.00	$1,900.00	-$100.00	$-	$-	$-	$-	$-	$-	$-
			13	Project 13				-$100.00	-$100.00	-$100.00	$-	$-	$-	$-	$-	$-	$-
		INFRASTRUSTURE	15	Project 15				$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$0.00
			16	Project 16				$0.00	$150.00	$150.00	$150.00	$150.00	$150.00	$150.00	$150.00	$150.00	$250.00
UNSECURED	REVENUE by Full Contract Value	INFRASTRUSTURE	30	Project 30	75%	$10,000.00	4000									$1,000.00	$1,000.00
			31	Project 31	10%	$20,000.00	10200
			32	Project 32	20%	$30,000.00	10000
		URBAN	21	Project 21	10%	$40,000.00	37000								$1,000.00	$1,000.00	$1,000.00
			22	Project 22	15%	$50,000.00	42000										$2,000.00

<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col span="5"><col span="2"><col><col span="2"></colgroup>

Again, not entirely sure if this will be possible, but please let me know if anyone has any ideas.

Thank you,