Auto Population of cells

HI Hoping for some help on some formulas / coding

One workbook but about 25 worksheets

The first worksheet is the Mater Worksheets, with 4 critical columns

A B C D
Txt Txt Numeric Date

This worksheet has about 800 lines

What I want to be able to do on subsequent worksheets is

1) Manually enter a value in Column A, have this value checked against Column A on the Master Worksheet, and then have Columns B, C & D auto-populate with the corresponding values from the Master Worksheet

2) And, if the value in column C & D on the Master Worksheet change, for this to be reflected on the subsequent worksheets.

If this combination of is not possible there may be a simpler solution, given that the user has already manually populated all these work sheets!!

The alternative is a formula for the subsequent worksheets. On these worksheets check the values of Column A & B, find the corresponding entries in Column A & B on the Master Worksheet and then enter the values of Columns C & D from the Master Worksheet into the subsequent worksheets, Coulmns C & D.

I'm sure I've made this over wordy but hopefully you get my drift.

Many thanks in advance.

Dermot

Hi Everyone

Iam new to the Excel program and new to this forum so iam sorry if my questions are stupid
and also if iam in the wrong thread i apologise. Iam trying to do a invoice spreadsheet where it calculates the total hours worked and the hourly rate and gives the total in dollars so far got that but when i have to calculate the GST which is 10% it automatically adds the 10% to the total price which is good but i want it to show how much in dollars is the GST and not a percentage like it is atm. Hopefully my question makes sense lol

Thanks Lem

Sample of the Master Worksheet
Master Worksheet Sample.jpg

Column A is a Reference number which can be numeric or alphanumeric. It is possible for Column A to be blank and a valid entry still be in Column B (Example not shown). If A & B are blank the line can be ignored. In total there are about 800 lines on this worksheet.

Sample of subsequent worksheet
Other Worksheet Sample.jpg

These worksheets are a subset of the Master Worksheet with the data to be included dependent on 'Job Role'

So either need a method to auto complete columns B, C & D when a valid entry is made in Column A

or a method to automatically update Columns C & D when changes are made on the Master Worksheet. This would work as someone has already manually completed the worksheets but now wants a method just to update C & D automatically.

Many thanks

Dermot

Think I have now come up with an appropriate solution using VLOOKUP. thanks for the prompt Lem

Dermot