Auto populate items on subsequent tabs based off information on overview tab

Hi All,

Apologies if this has been answered elsewhere in the thread - please point out to me where this was covered and I'll happily go and review that.
Secondly, apologies if this is straight forward. I am very new to this!

I have a spreadsheet I'll be using to track certain items of my projects. There are multiple tabs which contain varying information on the different aspects. I have two questions:
1) The Overview Tab will be manually populated with the details. There are certain items that will be transferred across the other tabs (Identifier / Perform Code) - is it possible that, if the identifier is entered on the other tabs, the spreadsheet could auto-populate the Perform Code, based on the information within the Overview tab?

2) Is it possible that, when Chargeable = Yes (Y) on the Tickets/Actions tab, this information auto populates on the Chargeables tab, so this tab encompasses the chargeable aspects of both of these times for easy review?

Many thanks in advance for your help!