copy data from sheet to another based on multiple criteria

[MKLAQ]

hi experts

this is the first post and I know what I request is very huge and may be very complicated but honestly, what I see in this forum there are many members help each other and I have no experience about the vba so what I want I have sheet contains many data for many customers and I have another sheet this should show the result for many standards

1 if I select the only from cell a1 the name should bring the data for this name from sheet "process

2 if I select the the cell a1 & a3 , b3 then bring all of the for this name which locates between two dates

3 if I select only a3,b3 then brings all of data for many names which locates between two dates

4 if I the cells a1,a2,a3 are empty should bring all of data

this is general explanation but I have more details in the file and how shows the result and how bring the values and calculate

if the explanation is not clear I'm ready to make clear more
I put simple sample in sheet "result" to understand how is the result
Microsoft OneDrive - Access files anywhere. Create docs with free Office Online.

thanks in advance

 

[MKLAQ]

sorry but this is not my file

 

[mumps]

Oops!!!! Click here.

 

[MKLAQ]

wow!! your did much great work you give me a big gift and a big favor
thank you very much to help me in this project

 

[mumps]

You are very welcome.