Copy from various tables, paste into new sheet

[JoshLyman]

I think I'm going to need VBA to help me do this, but wanted to see if I could get confirmation first/a little help.

I have 6 tabs, on which I will be logging various bit of information which are relevant to that particular tab, but that will always include a 'Judgement code' and 'How can we improve'. I would like to pull whatever has been logged in these 2 cells, and paste them onto my summary tab into cells 'Judgement code' and 'How can we improve'. The rest of the cells in the summary tab table can be left blank, as they'll need to be populated with new information that isn't otherwise logged on the other tabs.

The tabs are:

• 'QOE Intent'
• 'QOE Implementation'
• 'QOE Impact'
• 'B&A'
• 'PD'
• 'L&M'

The summary tab is called 'QIP'

Below are extracts from the QOE Intent and QIP tabs, for reference

NEW Self-Assessment Report.xlsx
	B	C	D	E	F	G	H	I
66	Judgement code	Judgement description	Date	How do we do this?	What do we do well?	Grade	How can we improve?	Evidence/Measure
67	QOE_INTENT1	Leaders take on or construct a curriculum that is ambitious and designed to give all learners, particularly the most disadvantaged and those with special educational needs and/or disabilities (SEND) or high needs, the knowledge and cultural capital they need to succeed in life	20/02/2023	Test	Test	2	Test information	Test
QOE Intent

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G67:G70	Cell Value	=2	text	NO
G67:G70	Cell Value	=1	text	NO
G67:G70	Cell Value	=3	text	NO
G67:G70	Cell Value	=4	text	NO

Cells with Data Validation
Cell	Allow	Criteria
G67:G70	List	=Lookups!$A$2:$A$5

NEW Self-Assessment Report.xlsx
	B	C	D	E	F	G	H	I	J
17	Judgement code	How can we improve?	Responsible	Objective status	Expected impact	Target date	Completion date	Notes	Evidence
18
QIP

Hope this makes sense?