VBA to create invoice from several sheets and email

[englandmark]

This seems to be very challenging for me, but i will thank you in advance excel Guru's.
I have several sheets used for ordering from different divisions and also one for outside sales.
I would like to generate an invoice from any of the worksheets and send a PDF invoice to my coordinator for sending to the customer.
Thanks again for any help in advance guys and gals.

Goal
To create invoice from several order sheets and email when cell specifies yes to specific employee (Yes is selected Y in last column named Invoice)

Order sheets (Sheets named RH Commercial, RH Service, RH Residential, Aug Commercial, Aug Service, Outside Sales)

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Invoice #

Delivery

Customers Name

Address

City

State

Phone number

Date Ordered

Date fabricated

Job number

Job name

Description

Gauge

Quantity L/f

Girth

Sheets

Sheet cost

Material cost

Fab cost

Sell price

L/F Cost

RPI Price

RPI L/F or Each

RPI Discount

Invoice

<tbody>
</tbody>

Invoice (Sheet name invoice)
Invoice Number: D6 copy from cell A
Delivery: D29 copy from cell B
Customers name: B8 copy from cell C
Job Name: B9 copy from cell K
Job Number: D9 copy from cell J
Billing Address: B10 copy from cell D
City: B11 copy from cell E
State: B12 copy from cell F
ZIP: B13 auto generate from address
Quantity: A16 copy from cell N
Description: B16 copy from cell L
Unit Price: C16 copy from cell W, Outside Sales sheet copy U
Total: D16 copy from cell V, Outside Sales sheet copy T

If same customer same address same date fabricated and yes selected add below A16, B16, C16, D16 and below on same invoice
(Multiple products same order)

Invoice range A1:D33
Create PDF attachment to email and send to soandso@gmail.com

 

[englandmark]

VBA help needed here guys
Anyone help with this code?
Thanks
Mark

 

[Macropod]

Cross-posted at: http://www.vbaexpress.com/forum/showthread.php?64282-VBA-code-help-invoice-from-several-worksheets
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html
With all your duplicates & cross-posts, you really do seem to have contempt for Mr Excel's rules. Keep it up and your posting privileges may be revoked.

 

[englandmark]

I do appoligise, as you can see they were prior to your original notice.
I understand and will follow as you have explained

 

[englandmark]

I didn’t realize the two sites were linked
I am now aware thanks

 

[Joe4]

I didn’t realize the two sites were linked
I am now aware thanks

The sites are NOT linked.

The issue is Cross Posting without links can result in people needlessly wasting time suggesting things that may have already been suggested, or working on a problem that might have already been solved elsewhere. Read this, and I think you will understand: https://www.excelguru.ca/content.php?184