Excal vba sheet

Excal VBA Sheet for Automated Calculations of Sales Data

We are looking for a VBA expert to help us create an Excal VBA sheet that can perform automated calculations for our sales data. The ideal candidate should have experience in VBA programming and data analysis.
I have a daily sheet that we need to move data from one sheet oto a new layout including inserting new row and taking dats fro existing row
List oif things
Take list
Arrange in order from Column D (customer)
A1 ='order-item-details (14)'!AV2
But A2 stays blank until it changes from the line above then insert new

Column J1 Inv 2572 remain the same until Column A changes the J1 + 1

K = the range of orders in column c fo that customer example k5 this repeats until customer changes





L= ='order-item-details (14)'!AV2
M=='order-item-details (14)'!AV2 +7 days
P ='order-item-details (14)'!C2&" "&'order-item-details (14)'!BF2&" "&'order-item-details (14)'!BH2&" "&'order-item-details (14)'!BG2
=Q2
R='order-item-details (14)'!BJ2
T= “4021”
U= “20%(VATon Income)”



AB= “Invoice”


Adding delivery to each order insert a delivery row using the info from the first line of that order number
Every time column K changes insert line
P= =='order-item-details (14)'!AE21
T = 4014
U= “20%(VATon Income)”
AB= “Invoice”