COPY THE DATA from THE MASTER FILE TO THE DIFFERENT SHEETS AUTOMATICALLY

Hi nelcee

I would suggest 2 options:

1/ Use Index and match to look up the values from your 'Masterfile' sheet and put them in the cells you want to have filled up.

=INDEX(Return_value_range; MATCH(Lookup_value; Lookup_value_range; Match_type))
Return_value_range The range that holds the return values
Lookup_value The value you want to find in the lookup value array
Lookup_value_range The range containing lookup values
Match_type Exact (0), Nearest Less Than (-1), or Nearest Greater Than (1)

2/ Go a bit further and use PivotTable Report Filter Pages. You will need to invest some time first, to win time and great flexibility afterwards. Once this is set up, you only have to worry about the input ('Masterfile'). Output (all the other sheets) is easily generated (and re-generated) with a few clicks.

2a/ Turn your data into a Table (Insert > Table).
-->This is optional, but I recommend it because it turns your data in a dynamic range. Also, input and manipulation are easier.
2b/ Create a PivotTable based on your Table ( Table Tools > Design > Summarize with PivotTable) (OR: Insert > PivotTable)
2c/ Set up your PivotTable, putting your column D 'Account Names' in the Report Filter
2d/ Create a worksheet per Account Name. (PivotTable Tools > Options > Options > Show Report Filter Pages)

If you're new to Tables and PivotTables, I'dd suggest to find some tutorials and play around with them.

Good luck!
Sleezypeazy