Macro using Name entered in specific cell

[JABWootton]

I am attempting to write a macro for the following
I have a list of date in various cells which are updated daily
A sort needs to be done in each worksheet where a certain person is in charge of various projects.
I can do it manually by selecting the data and doing a sort by name or I can create a simple macro where it does this for me.
As the names change monthly this is becoming time consuming as I need to change the macro to show the new persons name
What I need to do is create a macro where that persons name is entered into a cell in a separate worksheet, the macro is the run and the results are sorted in the relevant worksheet.
Any questions please feel free to ask
Thanks in Advance

 

[venkat1926]

dim name as string
name=range(...).value

e.g.f the name is tempoarily parked in L1
then
name=range("L1").value


and then work on the variable "name"

venkat

 

[JABWootton]

dim name as string
name=range(...).value
e.g.f the name is tempoarily parked in L1
then
name=range("L1").value
and then work on the variable "name"
venkat

Thanks but totally lost
only used to entering very very simple macros through the record button and then amending the macro manually
how do i put the above in macro

 

[venkat1926]

sorry

you post an extract of your sheet and also decribe what exactly you want with respect to that extract