which one to use: Macros / Formula's / Lookup

[aussiegirlone]

I have created an Employees Roster have got 15 sheets each Titled as a Site
Location. Then I have got another 15 sheets, each with the name of a single
employee. What I would like to do is have the employees Roster Sheets
automatically search all the Site Sheets for the data entered. Thus, what
ever is entered into the site sheets it automatically enters the data into
the corresponding employee. If this is possible, can anyone help with a
formula or macro to do this?
Aussiegirlone

Data entered here
↓
Sheet Name: ParkPatrols
Name Start Finish Sun Mon Tue Wed Thu Fri Sat
Total Hours
???? 12:00 pm 16:00 pm yes
4

Goes automatically here
↓
Sheet Name: Employee (1)
???? Lic Number 1234567
Day Date Start Time End Time Site Total Hours

 

[aussiegirlone]

I'll give you the information that you want, if you tell me what information
you want.
Can you give me an example of your suggestion please?

 

[aussiegirlone]

I think to understand you slightly! I need to be able to collect all the data
of each employee for the total week as the roster needs to be printed out and
sent to each employee on a weekly basis. The data should be able to
accumilate as the weeks go by without duplications. Thus, I should be able to
see previous weeks of each employee's Data.
Maybe if I send you two Site sheets and two employee sheets then you might
see what I want a lot better?

 

[aussiegirlone]

I think to understand you slightly! I need to be able to get all the data in
the site sheets for the total week of each employee. The roster is then to be
sent to each employee on a weekly basis. The data collected should accumulate
as the weeks go by without duplications.
Maybe I should send you a copy of two site sheets and two employee sheets if
that would help

 

[aussiegirlone]

I have now become a member of thecodecage.com so now I ask where do I put
your suggested code (in what sheet(s)

(links found below)